RE: ODBC Sort not working
The following response was previously posted as a solution to this issue:
Upgrade your ODBC driver to v3.11 to enable you to use the following
workaround ... from
http://www.intersolv.com/datadirect/download/docs/odbc/Readme/95ntread.htm
WorkArounds=1073741824. Microsoft Access assumes that ORDER BY columns
do not have to be in the SELECT list. This workaround addresses that
mistaken assumption for data sources such as INFORMIX and OpenIngres.
Good luck..
> -----Original Message-----
> From: granta@nospam.student.canberra.edu.au
> [mailto:granta@nospam.student.canberra.edu.au]
> Sent: Tuesday, November 16, 1999 16:20
> To: informix-list@iiug.org
> Subject: 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
> :-)
>