Responding to Error Codes

Go Up to InterBase Status Array

After any error occurs, you have the following options: ignore the error, log the error and continue processing, roll back the transaction and try again, or roll back the transaction and quit the application.

For the following errors, it is recommended that you roll back the current transaction and try the operation again:

Status array codes that require rollback and retry

Status array code	Action to take
isc_convert_error	Conversion error: A conversion between data types failed; correct the input and retry the operation.
isc_deadlock	Deadlock: Transaction conflicted with another transaction; wait and try again.
isc_integ_fail	Integrity check: Operation failed due to a trigger; examine the abort code, fix the error, and try again.
isc_lock_conflict	Lock conflict: Transaction unable to obtain the locks it needed; wait and try again.
isc_no_dup	Duplicate index entry: Attempt to add a duplicate field; correct field with duplicate and try again.
isc_not_valid	Validation error: Row did not pass validation test; correct invalid row and try again.