Informix/Access Sorting Bug?

Posted in 1998

Curt Van Den Heuvel — 26 Jan 1998 09:28:01 -0700 — source: Informix-list mailing list archive (1991-1998)

I have an Access-97 database which contains several linked informix 7.23 tables (using Informx CLI-32 to connect). If I try to order by an column other than the primary key, I get the following error from the ODBC driver : "COLUMN whatever MUST BE IN ORDER BY LIST". I put a trace on the ODBC driver, and indeed it was trying to order by the specified column without having it in the SELECT list. Question: Does the SQL command originate with Access, Informix-CLI or the ODBC driver? Thanks, Curt -- Current Daytime Phone: (201) 825-4000 x6314