[AccessD] Informix, Boolean

Hi John

Thanks, that was along one my thoughts - is Boolean a Boolean?
But if you study the linked table in design view, it tells type Yes/No for that field.

I wouldn't need the manuals. IBM has done a nice work putting up all official info on the web - but I guess simply not that many Informixolics use Access for access ...

/gustav

>>> john at winhaven.net 05-01-2006 18:40 >>>
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