[AccessD] Informix, Boolean

Gustav Brock Gustav at cactus.dk
Thu Jan 5 06:03:11 CST 2006


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




More information about the AccessD mailing list