Articles:

• Find duplicate rows in a table (no primary key) (125981)
• SQL: Find duplicate rows in a table (with a primary key) (99972)
• QuickReport: Load a .QRP file (39734)
• How to fix BDE Error '2B04 Too many open files' (18654)
• Copy the current record of a dataset (17671)
• Getting the installed ADO version (17220)
• Compact and repair an Access database from Delphi (17191)
• Row-Level Locking in MSSQL 7 (16724)
• Today's date on database server (16634)
• Retrieve all tables in a database with ADO (16331)
• Paradox limits (16284)
• Resource or Limit error (BDE error message) (16185)
• General BDE Limits (16149)
• I/O Error during OpenFile OF_READWRITE (15931)
• 'Cannot find engine configuration file' error message (BDE config file) (15396)
• Print a selection on the non-default printer with QuickReport (15203)
• FoxPro limits (15191)
• Connect to server databases (InterBase) without the login dialog (15176)
• Create an index for a TClientDataSet at runtime (15033)
• How to save a QuickReport custom preview to text? (15031)
• MS-SQL : connection is in use by another statement (14860)
• Obtaining more information about BDE Errors (14733)
• Porting InfoPower 4 to Delphi 5 (14682)
• QuickReports: PrinterIndex out of range (14554)
• Create a dBase database at runtime (13919)
• Access violation when calling a non-delphi VCL created DLL (13893)
• Place a DBLookUpCombo in a DBGrid (13726)
• 'Nonsense' error message 'parameter mismatch for procedure' (13684)
• More than one 'NETDIR' for the BDE on one computer (13604)
• Check the BDE version in your application (13596)
• Locate() fails with 'Variant conversion error' (13417)
• How to set a NULL value through the VCL (13392)
• Determine the version of the BDE (13330)
• Assign a password to a Paradox table (13321)
• Detecting database changes (13154)
• Copy/ delete a BDE table (13043)
• Couldn't perform the edit because another user changed the record (12992)
• Extracting the Month of a Date (12956)
• How to specify a DefaultExpression for a TField object (12865)
• Filter operation on a lookup field (12814)

Keep a dataset in dsInsert/dsEdit mode after validation fails If you want to keep a dataset in dsInsert/dsEdit mode after a validation fails, but do not want to loose your input, use Abort in the BeforePost() event. (If you would use Dataset.Cancel, you'd loose the input and return to browse mode.) procedure TForm1.Table1BeforePost(DataSet: TDataSet); begin if Table1ID.Value <= 0 then begin // the data is invalid!! Showmessage('Error! Invalid value!'); Abort end else Table1.Post; end;