[V4RB] Queries with boolean fields

[Stan Busk]

Hi,

The following Query crashes:

SELECT * FROM myTable WHERE (myField1=2 OR myField2=3) AND myField3=0  
AND myField4=1

myField3 and myField4 are Boolean.

The following Query doesn't crash:

SELECT * FROM myTable WHERE (myField1=2 OR myField2=3) AND NOT  
myField3 AND myField4

Am I correct to not use the =0 and =1 anymore but rather the field  
directly and 'NOT' for false values?

~/Stan