Hi Durga, double entries in the database shouldn't work. Seems to be a bug. Are these double entries have the same content? Or is it different?
As I see your are inserting the same data through to different ways, right? Artur --------- Am 28.12.2009, 14:04 Uhr, schrieb Durga D <durga.d...@gmail.com>: > Hi All, > > I am developing an application with Sqlite3 Database in VC++ 6.0. > Here, > I tried for bulk insertions with CppSQLite3Statement. But, It's allowing > duplicate records in my database even primary key existed. > > First, I inserted 50000 records with insert query and transactions for > every 25000. > Second, same data inserted by prepared statement CppSQLite3Statement > and > transactions for every 25000. > > Create Table Query: create table TestDB (Column1 INTEGER ,Column2 > TEXT(1120) > primary key collate nocase,Column3 INTEGER ,Column4 TEXT(1120) ,Column5 > TEXT(1120) ,Column6 INTEGER ,Column7 TEXT(1120) ,Column8 INTEGER ,Column9 > INTEGER ); > > Surprised. Can anyone clear my doubt? > > How to resolve this issue? > > Regards, > Durga > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users