Re: Informix/Access Sorting Bug?

Curt Van Den Heuvel <heuvelc@primenet.com> wrote: >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 I have experianced the same problem. I did some extensive testing and here is what I found: --- Informix CLI version 2.50TD1 ---- Error complaining about column must be in order by list. --- Informix CLI version version 3.0 --- ships with Informix Data Director for Visual Basic and is also available from Intersolv --- no problems. --- OpenLink (any version) --- no problems. *************************************************************** Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com ***************************************************************