Page 1 of 1

update failed found 2 records

Posted: Mon 07 Jun 2010 14:41
by sandy771
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.

Posted: Mon 07 Jun 2010 15:25
by bork
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.

Posted: Tue 08 Jun 2010 16:08
by sandy771
That seemed to work thanks