Re: ORDER BY within REPORT routine

Ian Clark wrote: > > Hi All, > > When writing reports within 4GL programs I usually end up with my > usual SELECT...FOREACH...OUTPUT TO REPORT scenario. > > The ordering is usually done with the initial SELECT statement. > > What I would like to know is in what circumstances should I consider > using the ORDER BY statement within the REPORT routine? Would the > report be produced any quicker, is it more efficient and is it any > easier? > > Any views/comments would be very welcome. > > Cheers, Ian. I think it is there mainly for use with ASCII file input. I'd guess the engine would be better just about every time. I haven't tested it, though. -- 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/