ESQLiteError "constraint failed"

skippy · Post by **skippy** » Tue 03 Nov 2009 22:58

Hi,

using SQLite with UniDAC I always get an exception "constraint failed" at any point in time, can't really find out where exactly, or under which circumstances.

Anyone having an idea ?

Thanks

Plash · Post by **Plash** » Wed 04 Nov 2009 10:38

You may get this error if you insert records with duplicate primary key values.

skippy · Post by **skippy** » Wed 04 Nov 2009 15:12

But the Primary Key Value is the AutoIncrement ID:

[ID] INTEGER PRIMARY KEY AUTOINCREMENT,

Plash · Post by **Plash** » Fri 06 Nov 2009 12:27

Check what other constranits your table has. It could be UNIQUE or CHECK constraints.

skippy · Post by **skippy** » Sun 29 Nov 2009 10:37

Yes, there was another unique index, I was first looking in an older version of the table...

Thanks for the hint and *this DB component is really great*

Rgds