Delphi / Object Pascal · Database exception
What does BDE Error 9729 ($2601) - Key Violation mean in Delphi / Object Pascal?
The SQL-link and referential-integrity category's key violation error, distinct from the local-table KEYVIOL code, raised when a database-level unique constraint or primary key is violated by an insert or update.
The SQL-link and referential-integrity category's key violation error, distinct from the local-table KEYVIOL code, raised when a database-level unique constraint or primary key is violated by an insert or update.
Validate uniqueness in the application before submitting the write when possible, and catch this code specifically to show a friendly duplicate-value message instead of the generic BDE error dialog.