Re: -MAJOR- ODBC order by bug?

Jay, OpenLink Software's High-Performance ODBC Drivers for Informix do not have this problem. A free non expiring eval is available at: http://www.openlinksw.com Regards, Kingsley Idehen OpenLink Software Jay Hannah wrote in message <352AAF6E.D12C9185@jays.net>... >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