[AccessD] Informix, Boolean

Hi Gustav,
When I used Informix (a long time ago) it did not have a boolean field type.
The data type "Byte" was actually binary as in BLOB data.
The data type "Numeric" was a synonym for "Decimal" defined as "a number
with defineable scale and precision" which IIRC would correlate to a Single.
The data type "Float" was double precision - IIRC the same as "Double".

I have some old informix manuals in pdf form if you'd like them.

John B.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, January 05, 2006 6: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