SQLite, Boolean & AsBoolean...

[Runspect]

I try to update a Boolean field:

Code: Select all

ZQuery.FieldByName('FieldName').AsBoolean:= TRUE;
ZQuery.Post;
ZQuery.ApplyUpdates;
Connection.Commit;   

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?

[Runspect]

I solved with changing "WHERE Field;" to "WHERE (Field= "Y");" in SQL stament.