Page 1 of 1

Delete throwing wierd error

Posted: 17.02.2017, 22:58
by ToodleDoo
Hi, Ubuntu-14.04, SQlite3, Zeos 7.1, Lazarus 1.6.2

I am getting this error when I try to Delete from a zTable. I can do everything else OK, Insert, Edit, Cancel, Post, but not Delete.

Code: Select all

  dm.tblAccounts.Delete;
What am I doing wrong?

[FOUND] Delete throwing wierd error

Posted: 18.02.2017, 19:25
by ToodleDoo
OK, found the problem. It is using two Fields in the IndexFieldNames.

If I have
tbl.IndexFieldNames:='Sequence;Account';

It deletes one time then after that subsequent Deletes (immediately following) will cause the crash in the OP.

If I just have
tbl.IndexFieldNames:='Account';

Deleting is normal and no errors.