Design


Articles

Sort by: Page 4 of 9 | Previous | 1 2 3 4 5 6 7 8 9 | Next
DateTitleAuthorType
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

Server Response from: ETNASC03