June 22nd, 1999, 10:48 AM
Since this just bit me in the hiney, thought I'd post it.
Using CDaoRecordset against dBase databases if I query based on a logical field, it appears that you need to test against inequality.
Ie
Select * From some.dbf Where (Logical_Field=1); // Fails
Select * From some.dbf Where (Logical_Field=0); // Okay
but
Select * From some.dbf Where (Logical_Field<>0); // Succeeds.
Using CDaoRecordset against dBase databases if I query based on a logical field, it appears that you need to test against inequality.
Ie
Select * From some.dbf Where (Logical_Field=1); // Fails
Select * From some.dbf Where (Logical_Field=0); // Okay
but
Select * From some.dbf Where (Logical_Field<>0); // Succeeds.