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.
TCRBatchMove - bmAppendUpdate error
Hello,
Please send me a complete small sample to alexp*devart*com to demonstrate it, including a script to create the table.
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.
I could not reproduce the problem.When I try to append and update records in sqlite database I got ESQLiteError 'database is locked'.
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.