Re: ODBC Sort not working

On Tue, 16 Nov 1999 19:56:15 +0100, Bernhard Gramberg <mail@gramberg.de> wrote: >When I use a ODBC-Connecting,i.e. with MS-Access, >When i want so sort by any field, >it get the error-message > >sort field must be in the Select list. > >When looking at the SQL-Statment, correctly, all fields are >inlcuded. > >Any idea, what could be wrong. >Any new ODBC-Driver or what else could solve the problem Send us a sample statement. The error usually crops up when you have a statement like select a,b,c from mytable order by d d must be in the select clause for Informix. i.e. select a,b,c,d from mytable order by d Ciao Fuzzy :-)