Database


Articles

Sort by: Page 1 of 4 | 1 2 3 4 | Next
DateTitleAuthorType
31 Mar 2003 "Cannot transliterate" error
A possible reason for getting a "Cannot transliterate character between character sets"
Ben Matterson FAQ
21 Jul 1999 30 Days from Paradox to InterBase
This article reviews the problems, the band-aids, the solutions, and the successes encountered during a large database migration from Paradox to InterBase
Skip Rowland White Paper
24 Jul 2000 Ability to create a database using the API call
API call "isc_dsql_execute_immediate()" may set you databse habdles to NULL
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 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
20 Sep 2000 An Introduction To InterBase
written by Marcus Kemper, presented at BorCon 1998
Borland Staff White Paper
24 Jul 2000 Are the ports which InterBase and InterClient use officially registered?
The ports that InterBase and InterClinet use are officially registered
Borland Staff FAQ
24 Jul 2000 Bulk Inserts with InterBase
5 different reaons bulk inserts might be slow
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
21 Jun 2002 Creating a primary key when your table has no unique records
Describes a simple technique to add a key regardless of the format of your data
Quinn Wildman FAQ
1 May 2002 Creating case insensitive table field names
A tip for getting around case sensitivity in dialect 3 databases.
Ben Matterson FAQ
24 Jul 2000 Date Arithmetic
Date arithmetic examples for InterBase 4.x and 5.x
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 Does InterBase 4.2.2 for NetWare 4.11 support IntranetWare 4.11 SFTIII?
Forced Writes may conflict with SFT's I/O stream. Therefore, it may be better to turn it off (use the Windows InterBase Server Manager utility).
Borland Staff FAQ
24 Jul 2000 Does InterBase have the ability to import ASCII files?
Fixed length is supported. Delimited is not.
Borland Staff FAQ
24 Jul 2000 Dropping Generators
It is not possible to drop a generator
Borland Staff FAQ
24 Jul 2000 Dynamic SQL Error: Token unknown
InterBase version 4.0 and onwards, is pretty strict about the usage of reserved words in any SQL statements..
Borland Staff FAQ
24 Jul 2000 Error: The shadow path was deleted from database due to unavailability
File permissions may cause this error
Borland Staff FAQ
24 Jul 2000 Escape clause {oj} fails to function
Escape clause {oj} fails to function since upgrade to ODBC driver version 2.00.903.
Borland Staff FAQ
24 Jul 2000 GBAK of external files functionality has changed between v4.x and v5.x
Be aware that we have changed the way that backup and restore external files between v4.x and v5.x.
Borland Staff FAQ

Server Response from: ETNASC01