update failed found 2 records

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sandy771
Posts: 194
Joined: Tue 22 May 2007 13:57

update failed found 2 records

Post by sandy771 » Mon 07 Jun 2010 14:41

I have a sqlite table with about 10K rows.

I an stepping through every row and updating a single record each time.

About 3/4s of the way through the process I get the above error.

Any ideas.

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Mon 07 Jun 2010 15:25

Hello

It means that you have duplicated records in your table. If you have a primary key in your table then you should specify fields from it in the KeyFields property of TuniQuery (or TUniTable). If you don't have primary key then you should create a unique key and specify fields from this unique key in the KeyFields property of TUniQuery (or TUniTable).

Please provide us the UniDAC version you are using.

sandy771
Posts: 194
Joined: Tue 22 May 2007 13:57

Post by sandy771 » Tue 08 Jun 2010 16:08

That seemed to work thanks

Post Reply