Re: [sqlite] Bulk Insertions allowing duplicate records even primary key existed

[Artur Reilin]

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 :

> 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 5 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

[sqlite] Bulk Insertions allowing duplicate records even primary key existed

[Durga D]

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 5 records with insert query and transactions for
every 25000.
   Second, same data inserted by prepared statement CppSQLite3Statement and
transactions for every 25000.

   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