Articles:

• BDE error codes (1096)
• Couldn't perform the edit because another user changed the record (361)
• QuickReport: Load a .QRP file (352)
• Resource or Limit error (BDE error message) (265)
• Obtaining more information about BDE Errors (224)
• Connect to an Access Database with ADO and write a BlobStream value (213)
• MS-SQL : connection is in use by another statement (163)
• Retrieve all tables in a database with ADO (162)
• Find duplicate rows in a table (no primary key) (154)
• Read an image from a blob field in SQL database (148)
• What to do about $210A error message (145)
• How can Delphi access a mySQL database? (144)
• SQL: Find duplicate rows in a table (with a primary key) (142)
• How to save a QuickReport custom preview to text? (141)
• Place a DBLookUpCombo in a DBGrid (139)
• Today's date on database server (129)
• QuickReports: PrinterIndex out of range (126)
• Data Integrity Violation (BDE error message) (122)
• QuickReports preview has buttons without glyphs (120)
• Create an index for a TClientDataSet at runtime (119)
• Copy the current record of a dataset (118)
• Compact and repair an Access database from Delphi (115)
• Customizing the display of IBObject queries (115)
• TClientDataSet: Temporary vs. permanent indices (114)
• Access a password-saved paradox database without knowing the password (111)
• FoxPro limits (107)
• How to fix BDE Error '2B04 Too many open files' (105)
• Print a selection on the non-default printer with QuickReport (105)
• Paradox limits (103)
• General BDE Limits (102)
• I/O Related Error (BDE error message) (102)
• Delphi 3 & Access (100)
• More than one 'NETDIR' for the BDE on one computer (100)
• Add database aliases to BDE at runtime (98)
• How to specify a DefaultExpression for a TField object (98)
• Physical Data Corruption (BDE error message) (97)
• Row-Level Locking in MSSQL 7 (97)
• Object of Interest not Found (96)
• Keep a dataset in dsInsert/dsEdit mode after validation fails (92)
• Detecting database changes (90)
• Access violation when calling a non-delphi VCL created DLL (89)
• Filter operation on a lookup field (89)
• BDE alias info (89)
• Assign a password to a Paradox table (87)
• Package file name of QuickReports (87)
• Create a dBase database at runtime (85)
• I/O Error during OpenFile OF_READWRITE (84)
• Error: 'Trying to append data to a non-partial dataset' (83)
• Copy/ delete a BDE table (82)
• Porting InfoPower 4 to Delphi 5 (82)
• How to set a NULL value through the VCL (81)
• Connect to server databases (InterBase) without the login dialog (78)
• Extracting the Month of a Date (78)
• Allow Incremental Searching in your TDataSets (76)
• Getting the installed ADO version (75)
• Replace the SQL wait cursor (75)
• 'Nonsense' error message 'parameter mismatch for procedure' (74)
• Locate() fails with 'Variant conversion error' (74)
• Check the BDE version in your application (74)
• Accessing the row with the maximal value (74)
• Passwords are lost after ALTER TABLE (73)
• Changing Primary Index (71)
• Update controls bound to a query without a primary index (71)
• Decrementing a datetime field in Paradox (71)
• Determining the record number in a dBASE / Paradox table (69)
• Stored procedures in a multi-tier environment (69)
• List of all ALIASES pointing to a SQL server (69)
• Determine the version of the BDE (67)
• EOleException with Delphi and Access (58)
• "Cannot find engine configuration file" error message (BDE config file) (37)
• What do do about "Index is out of date" ($2F02) or "Blob has been modified" ($3302) (30)

Today's date on database server This is another case where ORACLE and InterBase SQL dialects are different. In ORACLE, it is SYSDATE, in InterBase, it is TODAY. // make the SQL dependent on type of DBMS if AppLibrary.Database.DriverName = 'ORACLE' then SQL.Add ('and entry_date < SYSDATE') else SQL.Add ('and entry_date < "TODAY"'); end; // SQL to query the date in ORACLE select to_char(sysdate, 'DD-Mon-YYYY HH24:MI:SS') as "Current Time" from MyTable;