SQLite, Boolean & AsBoolean...
Posted: 29.05.2016, 15:26
I try to update a Boolean field:
And It does not work, also I've tried (without success):
ZQuery.FieldByName('FieldName').AsInteger:= 1; //No error but nothing happens
ZQuery.FieldByName('FieldName').AsString:= 'Y'; //error: not boolean value
How can I make it work?
Code: Select all
ZQuery.FieldByName('FieldName').AsBoolean:= TRUE;
ZQuery.Post;
ZQuery.ApplyUpdates;
Connection.Commit;
ZQuery.FieldByName('FieldName').AsInteger:= 1; //No error but nothing happens
ZQuery.FieldByName('FieldName').AsString:= 'Y'; //error: not boolean value
How can I make it work?