Re: order by, limited functionality

Andreas Zeugswetter wrote: > > Does anybody know when > select col_a from tab_a order by col_b;> > will be supported ? > The inability for Informix to process such statements makes it > incompatible with > MS Access V7 and up. It is not in IDS 7.3. > > Andreas Zeugswetter I don't know but I do know some workarounds. In 4GL and ESQL/C it is possible to read the results of SELECT into a list of program variables shorter than the select list. So, you just put your order by columns at the end of the select list and hey presto! You do need to ignore the warnings, of course. Surely the only way up from MS Access v7 is to Informix :-). -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/