Re: Informix/Access Sorting Bug?

Curt Van Den Heuvel 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 noticed the same problem. Pass-through query seems to be working fine. If you know any other solutions, let me know. Another thing i noticed, that update query (updating access table with data from informix table) seems to be very slow. It is faster to do the select query, that returns all the records nessesery for update, and doupdate based on that query. Does not make any sence to me. Max. Max.