Board index » off-topic » CachedUpdates : ApplyUpdates failed
CachedUpdates : ApplyUpdates failed
2006-09-13 06:10:42 PM
Hi all !
I'm using CachedUpdates & UpdateSQL with BDE 5 and Delphi 7.
In the following case, i've systematicaly an error.
"table" is a TTable on a DBase IV file.
"database" is a TDatabase conneted to the directory containing the "table"
// Insert a record in a grid (using cachedupdates)
// delete the previous inserted entry using cached updates in a grid
table.ApplyUpdates =>raise an exception EDatabaseError with message "Update
Failed" (in french "Echec de la mise ?jour")
The "table" UpdateSQL insert statement is the following:
DELETE FROM MYTABLE WHERE (ID = :OLD_ID) AND (NAME = :OLD_NAME)
It seems to be a BDE bug. I'm looking for a solution, or a way to turn
Thanks a lot.