[AccessD] Informix, Boolean

Hi Charlotte

Yes, but why should that be needed?

Note, the query runs in Access using the attached file from Informix. 
According to the docs, an Informix Boolean field may contain Nulls but this table should not carry any Nulls only True or False.

If you run similar code in Informix as simple as:

  where field_boolean

it works. (=> only records with True values are returned).
Neither does this exact syntax work in Access.

/gustav

>>> cfoust at infostatsystems.com 05-01-2006 17:13 >>>
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