Re: informix ms-access sort problem

I'm not sure how your system is setup, but this error seems to be saying that you are trying to sort the data by a column or columns not in your select statement. SELECT a, b, c FROM tab... ORDER BY d, e will not work. The columns d and e must be in the select list. Arun Klaus Gotthardt wrote: > I tried using ms-access(97) as a frontend to informix(7.23,cli 2.5). It > worked, but i can sort only fields which are primary keys. > > (error: ....order by column (...) must be in select list (# -309)) > > -- > Klaus Gotthardt, > Johann Wolfgang Goethe-Universit't,Verwaltungsdatenverarbeitung > Email: K.Gotthardt@em.uni-frankfurt.de > Tel:+49 (0)69-798-23380 > Fax:+49 (0)69-798-23381 > Home,pgp-key: http://www.rz.uni-frankfurt.de/~gotthard