sqlite-odbc write conflict


am2

Joined
Sep 10, 2021
Messages
2
Reaction score
0
I try to connect a sqlite- database via odbc (http://www.ch-werner.de/sqliteodbc/).
I copied a table and added a primary key column to achieve this.

The table without PK (but with other constraints) is write protected, the table with PK seems to be writable. I can open the table, change the content of a field but if I want to move to another row to save the changes I get an write conflict error, row has been changed in the mean time. Of course no one changed this.

Has anybody an idea what I can/must do?
 
Ad

Advertisements

am2

Joined
Sep 10, 2021
Messages
2
Reaction score
0
It seems to connected to the date- fields.
If I try the same with a table without date fields it works.
If I remove the date fields from the mentioned table it works with this table too!

But it can not be the solution to kill all date- fields (or to alter it into text or sth like this.
Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top