[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