[AccessD] Informix, Boolean

Charlotte Foust cfoust at infostatsystems.com
Thu Jan 5 10:13:46 CST 2006


Gustav,

I don't know Informix, but the code that works suggests you have to
explicitly coerce the field, and particularly null values, from an
Access yes/no field to a boolean/bit value to make the comparison
succeed.  

Charlotte


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, January 05, 2006 4:03 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Informix, Boolean


Hi all

Didn't some of you have experience with Informix?

Why should you not be able to filter on a Boolean field in a linked
table in Access? Like:

  where field_boolean <> 0

which returns no records while this does:

  where CBool(Nz(field_boolean)) <> 0

Also

  where field_boolean <> "0"

gives a type mismatch error, thus field is numeric.

If no where clause is present, records with values of 0 and -1 are
returned ...

/gustav

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list