Re: User-defined sorting in Ace

---- you wrote: > Using ACE in Informix 7.2, I'm trying to let the > user define what sort order to use. I have four > fields that they can use, but no restriction as > to which order - it's being controlled by the > shell script that will pass parameters to the > report. For example, one run could be ORDER BY > fielda, fieldb, fieldc, fieldd, the next run > could be ORDER BY fieldc, fielda, fieldb, fieldd > > However, I don't seem to be able to get the > report to compile if I include parameters in the > ORDER BY clause. Am I wasting my time trying to > resolve this, or is there some way (no matter how > obscure) to achieve what I want. BTW, ACE has to > be the dev tool to use. I would say you are wasting your time Dude. If you have to use ACE, and the report isn't too fancy, then you could get ACE to output a simple listing, which you could get sort to sort on the requested fields. You could then use something like awk to add the column headings at the top of each page. ACE is good, but you can't beat 4GL. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com