Steven Van Ingelgem wrote:
How do I set a transaction (inserting items) to ignore doubles in keys?
As the default behaviour now is to abort/rollback...
I've also been looking where the sqlite_vm - structure is defined, but I
did not found anything... Is that normal? Or is it just a pointer to a
struct with nothing inside?
You cannot put duplicate values in a UNIQUE column or in a
PRIMARY KEY. Ever. The ON CONFLICT IGNORE clause does not
change this. The "IGNORE" does *not* mean to ignore the
constraint and do the insert anyway. It means to ignore
the insert - to pretend that the insert never happened - and
thus do not generate an error.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
