Re: informix ms-access sort problem

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 I presume the fields you wanted to sort by were in the list you wanted to display in Access? If not, the error message is to be expected and is a feature of standard SQL. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/