[V4RB] Queries with boolean fields

[Ruslan Zasukhin]

On 11/26/05 2:41 PM, "Stan Busk" <maxprog at mac.com> wrote:

> 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?

What if you right 

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

?


I think your case also should work.

Please send us db for check


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]