Devart Forums

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

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

But the Primary Key Value is the AutoIncrement ID:

[ID] INTEGER PRIMARY KEY AUTOINCREMENT,

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

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