View Incident Report

Serious

Reported By: Ralf Bertoldi
Reported On: 2/13/2006
For: Version 4.22 Build 5

# 2162 Updating a Table via SQL Inside of an AfterDelete Trigger for the Same Table Can Cause Record Skips

When updating the same table that refers to a trigger inside the trigger, sql commands could be skipped.

"DELETE FROM mytable WHERE (id BETWEEN 80 AND 90)"

Trigger:
"UPDATE mytable SET myfield='anything" WHERE id =10"

Every second DELETE is skipped.

Workaround for example:
Delete every record with a single statement.

Resolution

Fixed Problem on 3/6/2006 in version 4.23 build 1

Products Affected

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap