| Sort by:
|
Page 4 of 9 | Previous | 1 2 3 4 5 6 7 8 9 | Next
|
|
|
24 Jul 2000
|
Handling the "Too many versions" error when performing an ALTER statement.
InterBase only allows up to a maximum of 255 versions of each record in the system <BR>tables. Exceeding the limit produces the error.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Sorting Names Using Character Set - Collation Column/Table Definition
To solve this problem and to avoid a painful workaround of having an<BR>extra column that converts all characters to the same case, choose the right<BR>character set and collation order.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
what is the maximum length of the fields that comprise an index
The general rule here is that the total length of all fields must not be over 200 bytes.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Calling an IB stored procedure using TStoredProc
Short Delphi example that calls an Interbase Stored Procedure
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Dropping Generators
It is not possible to drop a generator
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Manipulating Dates Inside a Stored Procedure
Example procedures that add and subtract 30 days to/from today's date
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How are InterBase dates stored
Dates are two consecutive long words
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Retrieving Information about InterBase System Objects
Various examples using SELECT statements against System tables
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Bulk Inserts with InterBase
5 different reaons bulk inserts might be slow
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to get a list of all users available on the database
You can query the system table RDB$USER_PRIVILEGES to determine who has permissions to do anything
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Rounding numerical values in a stored procedure
A UDF is the best way to round a numeric value to an integer
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
What is the segment size and sub type of a blob?
The segment size determines the length of the data being sent. The sub type descrbes the contents of the blob.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Adding constraint foreign key failed with SQLCODE 607
Problem may occur if the referencing table's primary key is also a foreign key to another table.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
SCH_validate errors appear in interbase.log file
SCH_validate errors are internal server errors that are related to InterBase's internal scheduler.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Into which directory do I put UDF DLLs (Windows platforms)
InterBase uses the Win32 API function: LoadLibrary to load a UDF.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Changing Owner of Database
Only SYSDBA or the owner of a table can create a trigger for a table
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to calculate the age from a date field
A computed column can show the age
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Compiling UDFs on Unix
Example for compiling a UDF under Solaris
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Why InterBase is Year 2000 Compliant
InterBase is year 2000 compliant because of the way we store dates.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Embedding a carriage return into a column
Exporting an internal table to a text file requires that a 'newline' column contain a carriage return.
|
Borland Staff
|
FAQ
|
|
|
Connect with Us