Search found 3 matches

by JCollum
24.02.2009, 21:22
Forum: SQLite
Topic: sqlite administrator: querying boolean fields
Replies: 1
Views: 451

Not a bug, but could be improved. When I assigned a default for the BOOLEAN field, I put in 1, when it should have been Y. So the fix for the query was to use ='Y'. Dblinq was generating ='TRUE' instead of ='Y'.
by JCollum
24.02.2009, 17:17
Forum: SQLite
Topic: sqlite administrator: querying boolean fields
Replies: 1
Views: 451

sqlite administrator: querying boolean fields

I've set up a table called Photos. In that table there are two boolean fields, Public and Active. No rocket science here. However, when I query on those fields I get no records back (within SQLite admin). -- 4 rows, with Active and Public = true for all SELECT pics$.Caption, pics$.Id, pics$.Path, pi...
by JCollum
23.01.2009, 23:34
Forum: SQLite Administrator
Topic: Thank you
Replies: 0
Views: 1390

Thank you

Excellent. And free. Love it. Thanks for doing this.