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