On 14 Sep 2018, at 8:29pm, Andrew Stewart <astew...@arguscontrols.com> wrote:
> I am having problems with a database reporting Unique > Constraint Failed when doing an insert. > Table consists of 3 columns: > ID, DateTime, data > Constraint is on ID,DateTime. > > DateTime trying to enter is current time. We need to know what UNIQUE constraints are being applied. They could appear in the table definition or in any index for the table. What's the definition for the table itself ? It seems most likely that there's a UNIQUE constraint on DateTime, and you are inserting rows so quickly that two of them have the same DateTime. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users