Icon View Incident Report

Serious 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 Resolution
Fixed Problem on 3/6/2006 in version 4.23 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
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

Image