Design


Articles

Sort by: Page 1 of 9 | 1 2 3 4 ... 9 | Next
DateTitleAuthorType
30 Jun 2003 InterBase Community Tools and Solutions
Third party tools and solutions for InterBase
Aaron Ruddick Article
28 Aug 2001 Managing a birthday calendar with InterBase
User-defined functions are the key to remembering everyone's natal anniversary. By Marco Hemmes.
Marco Hemmes Contributed Article
27 Nov 2002 InterBase PLANalyzer 1.1 Released
InterBase PLANalyzer is a free tool to optimize IB SQL and metadata. Version 1.1 adds support for IB 5.6-7, query cancellation, syntax highlighting, and more.
Craig Stuntz Contributed Article
4 Mar 2003 Known Causes of Corruption in InterBase Databases
InterBase is, in general, a very stable database server and corruption is rare. When corruption does occur, then, it is important to determine the cause of the corruption. This article describes circumstances that can cause corruption.
Craig Stuntz Contributed Article
24 Jul 2000 Example of how to create a foreign key pointing to a compound primary key
Example for InterBase 4.x and later
Borland Staff FAQ
24 Jul 2000 Example of how to use the Union operator
Example for Interbase 4.x and later
Borland Staff FAQ
24 Jul 2000 Object In Use error when adding a foreign key
InterBase 4.x solves the problem
Borland Staff FAQ
24 Jul 2000 Date Arithmetic
Date arithmetic examples for InterBase 4.x and 5.x
Borland Staff FAQ
24 Jul 2000 Too Many Concurrent Executions of the Same Request
Caused by recursive triggers
Borland Staff FAQ
24 Jul 2000 Passing and Returning Dates to a Delphi-created UDF
A Protection Exception or erroneous results may occur if special precautions are not taken
Borland Staff FAQ
24 Jul 2000 Retrieving the first n records from a result set
It can be accomplished using a stored provedure
Borland Staff FAQ
24 Jul 2000 A Listing of Interbase-specific, and ANSI 92 SQL Standard Arithmetic Operators
A chart that lists the operators supported in InterBase and their order of precedence:
Borland Staff FAQ
24 Jul 2000 Bug No 8447: A For SELECT . . . SELECT in a Stored Procedure drops IBServer
Resolved in Interbase 5.0
Borland Staff FAQ
24 Jul 2000 Indexes Cannot be Created on COMPUTED BY Columns.
Generates error: unsuccessful metadata update, attempt to index COMPUTED BY column in INDEX <name of index>
Borland Staff FAQ
24 Jul 2000 Creating a Boolean/Logical datatype with InterBase
Booleans can be simulated by created a CHAR(1) with a check contraint that allows Y or N to be entered
Borland Staff FAQ
24 Jul 2000 Deleting from RDB$USER_PRIVILEGES is too slow in InterBase 4.0.
The ODS changed from 7.2 to 8.0 between versions, and when the two additional fields (rdb$relation_name, rdb$user) were added to the table (rdb$user_privileges) they were not optimized.
Borland Staff FAQ
24 Jul 2000 general sql error: violation of foreign key constraint
he problem occurs because you are using the incorrect type of Trigger
Borland Staff FAQ
24 Jul 2000 What is a generator?
General description of what a generator is
Borland Staff FAQ
24 Jul 2000 How do I create a generator?
Simple example creating a generator
Borland Staff FAQ
24 Jul 2000 How do I display the current value for a generator?
SELECT DISTINCT(GEN_ID(my_gen_id, 0))
Borland Staff FAQ

Server Response from: ETNASC03