Zeoslib Portal

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

I try to update a Boolean field: 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...

Do other datatypes exist startting with these prefixes? Not really, but according to the sqlite specifications: If the datatype for a column contains any of the strings "REAL", "FLOA", or "DOUB" then the column has REAL affinity By example a field named as "MyFloa...

Your ZeosLib DBO Version: The IDE you are using: Delphi Version (and maybe patchlevel) of the IDE: The database you are using: SQLite3 Version of the database: Used protocol: [hr] Error description and post In order to Column Affinity, see: http://www.sqlite.org/datatype3.html , "2.1 Determina...

To use 0/1 as Boolean value is better. Please, read this:

SQLite Users

Best Regards.