| Sort by:
|
Page 1 of 4 | 1 2 3 4 | Next
|
|
| Borland Staff |
|
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
|
Date Arithmetic
Date arithmetic examples for InterBase 4.x and 5.x
|
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
|
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
|
|
|
|
|
24 Jul 2000
|
How do I reset the value for a generator?
SET GENERATOR my_gen_id TO 0
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How do I assign a generator to populate my primary key with triggers.
Generators are assigned to keys via triggers
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
The definition of first, second, third, fourth and fifth normal forms.
Discussion of Database Design
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Accuracy of the NUMERIC and DECIMAL data types
How NUMERIC and DECIMAL fields are stored
|
Borland Staff
|
FAQ
|
|
|
|
|
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
|
Dropping Generators
It is not possible to drop a generator
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How are InterBase dates stored
Dates are two consecutive long words
|
Borland Staff
|
FAQ
|
|
|
Connect with Us