Delete throwing wierd error

[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?

[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.