Page 1 of 1

ApplyUpdate with exception "Record not found ..."

Posted: Tue 23 Mar 2010 09:26
by alosak
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.

Posted: Tue 23 Mar 2010 12:41
by Dimon
Please, try to download the latest DbxSda build (4.55.21) and check if this problem still exists.
If this does not solve the problem, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Posted: Fri 09 Apr 2010 15:56
by alosak
Dimon wrote:Please, try to download the latest DbxSda build (4.55.21) and check if this problem still exists.
If this does not solve the problem, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.
I already use dbxsda build 4.55.21. I tryed on another pc with another installation of ms sql 2008 but the same database and the same program: the exception was not present. If this situation is not able to help you to find the solution ... I 'll try to write an example with the exception.
Thanks in advance.

Posted: Mon 12 Apr 2010 12:15
by Dimon
I still can not reproduce the problem. Therefore I need a sample to demonstrate the problem.