Design


Articles

Sort by: Page 1 of 9 | 1 2 3 4 ... 9 | Next
DateTitleAuthorType
Borland Staff
26 Sep 2000 Writing Clean and Safe UDFs in Delphi
This article assumes the reader understands Delphi well enough to know how to create a DLL--We will demonstrate how to create UDFs, not DLLs.
Borland Staff TI
25 Sep 2000 How to Make Your Database Sound Better
This article is about making your database lightening fast.
Borland Staff TI
25 Sep 2000 Using InterBase Data Types
When one comes to InterBase for the first time in appears that some important data types are missing or difficult to implement. Not so. It is just a matter of knowing what to do.
Borland Staff TI
25 Sep 2000 Ten Things You Can Do To Make InterBase Scream
Increase the performance of your InterBase databases and applications.
Borland Staff TI
25 Sep 2000 Upsizing From dBASE to InterBase
This article is mostly about the theory behind client/server computing and the features of InterBase. There is no easier way, less expensive way to get your client/server feet wet than with the wonderful InterBase database server engine.
Borland Staff White Paper
25 Sep 2000 Upsizing Paradox Databases to InterBase
With forward planning and building on your database experience, you can move a relatively complex desktop database to the league of SQL database servers.
Borland Staff White Paper
20 Sep 2000 An Introduction To InterBase
written by Marcus Kemper, presented at BorCon 1998
Borland Staff White Paper
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

Server Response from: ETNASC02