ApplyUpdate with exception "Record not found ..."
Posted: Tue 23 Mar 2010 09:26
Hi,
I'm trying to use dbx component both for MSSql and FB to perform a lot of insert/update statement by ClientDataSet/DataSetProvider structure and Devart Dlls for Delphi2010 (my company uses the registration as [email protected]).
When the program execute the instruction
Clientdataset1.ApplyUpdates(0);
It generates the exception like this : "Record not found or modified by another user "
But if I manage the exception by try ... except the program insert or update the record despite the exception.
How to avoid the exception ?
Thanks in advance.
I'm trying to use dbx component both for MSSql and FB to perform a lot of insert/update statement by ClientDataSet/DataSetProvider structure and Devart Dlls for Delphi2010 (my company uses the registration as [email protected]).
When the program execute the instruction
Clientdataset1.ApplyUpdates(0);
It generates the exception like this : "Record not found or modified by another user "
But if I manage the exception by try ... except the program insert or update the record despite the exception.
How to avoid the exception ?
Thanks in advance.