ApplyUpdate with exception "Record not found ..."

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
alosak
Posts: 3
Joined: Fri 19 Mar 2010 18:27

ApplyUpdate with exception "Record not found ..."

Post by alosak » 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.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 23 Mar 2010 12:41

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.

alosak
Posts: 3
Joined: Fri 19 Mar 2010 18:27

Post by alosak » Fri 09 Apr 2010 15:56

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.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 12 Apr 2010 12:15

I still can not reproduce the problem. Therefore I need a sample to demonstrate the problem.

Post Reply