[yunqa.de] how to search for boolean value

  • From: Rael Bauer <rael.bauer@xxxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Mon, 29 Jun 2009 15:24:30 +0200

Hi,

I have a field in sqlite database declared as BOOLEAN, and also set it's
value with
Dataset.FieldByName('bool_field').AsBoolean. If I view the table in SQLite
Spy then values show up as true or false.

How do I construct a sql statement to search on such a boolean value, e.g:
select * from table where bool_field = TRUE.

I've tried a few options but none have worked so far :/

Thanks
Rael

Other related posts: