Oninit cdi / Archive
Talk to an expert →

Informix 4gl infant question

Posted in 1994

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design

Mike Rogoff — — source: Informix-list mailing list archive (1991-1998)

Hi, if anyone could help me with the following question it would be much appreciated (it's probably trivial). In a query comparing column names in a table to program variables (with '='), the query seems to fail when the program variables are NULL. Even if the column is null, the query doesn't match the row. (Data type is char[]). Thanks..... Newsgroups: comp.databases.informix Path: miker From: miker@nit.airtouch.com (Mike Rogoff) Subject: Informix 4gl infant question Message-ID: <CsJ7n4.4Av@nit.airtouch.com> Organization: PacTel Corporation References: <2v2ior$8du@emory.mathcs.emory.edu> Date: Wed, 6 Jul 1994 18:35:24 GMT Hi, if anyone could help me with the following question it would be much appreciated (it's probably trivial). In a query comparing column names in a table to program variables (with '='), the query seems to fail when the program variables are NULL. Even if the column is null, the query doesn't match the row. (Data type is char[]). Thanks.....

Glossary