Delete throwing wierd error

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
ToodleDoo
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 07.02.2017, 23:40

Delete throwing wierd error

Postby ToodleDoo » 17.02.2017, 22:58

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?
You do not have the required permissions to view the files attached to this post.
Ubuntu 14.04-LTS, Acer i5, 6GB, 256GB-SSD, Lazarus 1.6.2, Zeos 7.1

ToodleDoo
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 07.02.2017, 23:40

[FOUND] Delete throwing wierd error

Postby ToodleDoo » 18.02.2017, 19:25

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.
Ubuntu 14.04-LTS, Acer i5, 6GB, 256GB-SSD, Lazarus 1.6.2, Zeos 7.1


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest