Re: [sqlite] Detecting duplicate insert in bulk insert

t; <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, October 21, 2007 11:18 Subject: RE: [sqlite] Detecting duplicate insert in bulk insert Hello, Probably basic question, but I do not see it in the doc :( How do you insert in bulk ? Is it like in Oracle when you use ar

Re: [sqlite] Detecting duplicate insert in bulk insert

Hello Olaf, I do an "INSERT OR IGNORE" and in the STEP I count the changes to the DB. If there are no changes, then the insert was a duplicate. C Saturday, October 20, 2007, 8:31:05 PM, you wrote: OBL> Hi, OBL> I'm using a precompiled insert statement in a single transaction OBL> to perform a

[sqlite] Detecting duplicate insert in bulk insert

Hi, I'm using a precompiled insert statement in a single transaction to perform a bulk insert into a database table. I have a UNIQUE constraint on the same table to prevent duplicate inserts and this works well. However, I also want to detect and count the duplicate inserts, but when I insert