Devart Forums

Hello,

When I try to append and update records in sqlite database I got ESQLiteError 'database is locked'.

When try to only append records to a table which already have some records I got ESQLiteError 'constraint failed'.

And finally when try to append records to an empty table, this works fine.

My source database is Oracle.

Thanks.

Hello,

When I try to append and update records in sqlite database I got ESQLiteError 'database is locked'.

I could not reproduce the problem.
Please send me a complete small sample to alexp*devart*com to demonstrate it, including a script to create the table.

When try to only append records to a table which already have some records I got ESQLiteError 'constraint failed'.

If you have a UNIQUE constraint on a table and you try to do an UPDATE or INSERT that violates the constraint, the database will abort the operation in progress, back out any prior changes associated with the same UPDATE or INSERT statement, and return an error.

Hello,

We have reproduced your issue. We will notify you as soon as we have any results.