Re: -MAJOR- ODBC order by bug?

Jay Hannah <jay@jays.net> wrote: >Greetings -- > >It seems to be impossible to sort on char (or varchar) fields via Access >97 / ODBC linked to Informix... > >-------------------------- >create table sorttest ( > col1 int, > col2 char(20), > col3 varchar(20) >); >insert into sorttest values (1, 'A', 'A'); >insert into sorttest values (2, 'B', 'B'); >insert into sorttest values (3, 'C', 'C');> >[ Now, in Access 97: ] > >SELECT col1, col2, col3 FROM sorttest ORDER BY col1;> Works fine... > >SELECT col1, col2, col3 FROM sorttest ORDER BY col2;> [INTERSOLV][ODBC Informix driver][Informix] ORDER BY column > [col2] must be in SELECT list. (#-309) > >SELECT col1, col2, col3 FROM sorttest ORDER BY col3;> Same error... > >SELECT sorttest.col2 FROM sorttest ORDER BY sorttest.col2;> Same error... > >SELECT sorttest.col2 FROM sorttest ORDER BY 1;> Same error... > >SELECT sorttest.col2 AS c2 FROM sorttest ORDER BY c2;> Prompts for c2 (useless)... >-------------------------- > >This is a DEVASTATING bug (unless I'm just being stupid). > >Any ideas? > > >Thanks, > >Jay > >--- >DB-Access Version 7.20.UC5 >INFORMIX-CLI 2.5 (32 bit) 2.12.0000 >Microsoft Windows 95 4.00.950 (ODBC Data Source Admin 3.0.23.1) >Microsoft Access 97 This is a problem with the Informix 2.5 CLI drivers. If you purchase the latest version from Intersolv, the prolem goes away. There are also other ODBC packages that do not have the problem. ___________________________________________________________ Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com