I have a SQLite table accessed using Zeos TZQuery with SQL:
SELECT rowid,* FROM mytable
rowid | id_ext1 | id_ext2 | txt |
1 | 1 | 2 | |
2 | 1 | 2 | |
3 | 100 | 200 | some text |
4 | 1000 | 2000 | lorem ipsum |
Whenever I edit the first or second record in example table above, I always caught an exception says
"2 record(s) updated. Only one record should have been updated", which shouldn't happen because I explicitly request rowid to be present in resulting rows in order to prevent such multiple updates to happen. Anyone know how to, says, force ZQuery to acknowledge rowid as primary key in order to prevent such error?