On Thu, Sep 22, 2011 at 01:46:25PM +0200, Stephan Beal scratched on the wall: > On Thu, Sep 22, 2011 at 1:37 PM, neelakanta reddy < > reddy.neelaka...@gmail.com> wrote: > > > INSERT INTO "objects" > > VALUES(1309,155,'entryId=62,tableId=CPGMembersTable,CSId=1',0); > > <===============
> > INSERT INTO "objects" > > VALUES(1309,155,'entryId=99,tableId=CPGMembersTable,CSId=1',0); > > <================== > Where are they duplicated? The output you provide does not show any > duplicates (all have a unique 3rd column value). The PK (first column). The CREATE TABLE showed it as an INTEGER PRIMARY KEY, meaning that, if this happened as shown, the database would be corrupt. > i don't see any dupes in your inserts and you didn't present any > SELECT data which shows duplicates. Yes, please. Frequently when questions like this come up, the SELECTs don't actually show a problem. How are you inserting these? Your own code? Are you carefully checking all return codes? Do you actually know the dups are ending up in the database? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
