Re: what does this error mean???

Posted in 1999

have01@handelsbanken.se — Wed, 8 Sep 1999 11:46:42 -0400 — source: Informix-list mailing list archive (1991-1998)

This error occurs when the filter condition is containing an expression that is checked for NULL or NOT NULL. For Eg: SELECT avg(costprice) FROM table_t1 WHERE (costprice - sellprice) IS NOT NULL HTH Harinath Venkata Svenska Handelsbanken New York "Simon Leigh" <simon.leigh@btinternet.com> on 09/08/99 09:19:29 AM Please respond to "Simon Leigh" <simon.leigh@btinternet.com> To: informix-list@iiug.org cc: (bcc: Harinath Venkata/HAVE01/SHB) Subject: what does this error mean??? Reported as Error 40002: S1000: [INTERSOLV][ODBC Informix driver][Informix]IS [NOT] NULL predicate may be used only with simple columns. thanks Simon