Re: bizaar problem with 4gl reports

tony flaherty wrote: > > 4GL 6.05.UC1 > SQL 6.05.UC1 > ONLINE 7.21.UD1 > > I have a program which creates 6 or 7 reports open depending > on how it is being run. Some of the reports have ORDER BY > statements and some do not. > > When 7 reports are being created the last report does not produce > any output. when six are being produced it does. If I comment out the > ORDER BY from the report then output is produced. The report is being > closed Ok in both cases. > > I have dumped out all variables at the REPORT TO statement for the program > running in its two modes and there are no significant differences in the > contents > of the program variables. I have displayed the paramaters passed to the > report > both before the report is called and from inside the report an they hold > sensible > data. > > The ORDER BY is on two of the passed paramaters a CHAR(1), and a > CHAR(12). The other reports produced appear to work Ok. By commenting > out the order by I can see the contents of all data passed to the report, > its fine. > > I can't find any reference to this in the release notes. > > -- > > Tony > . > We come into the world and take our chances > Fate is just the weight of circumstances > That's the way that lady luck dances > Roll the bones... > . > Roll the bones - Rush 1991 Could you be running out of file handles? ORDER BY in a report sorts the data in the report. Try ORDER EXTERNAL BY and do the sorting in the 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 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.co.uk/