Re: ORDER BY statement inside a REPORT

Panos wrote: > > I have Informix 7.10 Online Server and Informix 6.04 4GL running on a > Unisys 6000-500/50 SMP server with two Pentiums. > > When I issue an ORDER BY inside a REPORT, because I want the rows to > be ordered inside the report, I experience the follwing problem. > > I have A FIRST PAGE HEADER statement with n rows, a PAGE HEADER > statement with m rows while pages are changed with SKIP TO TOP OF PAGE > statements. In the second page the internal LINENO does not calculate > correctly the line number after the PAGE HEADER rows, resulting to an > incorrect page change to the third page. This happens either with > explicit declaration of the page length in rows (66) or with changing > pages with ^L. > > Any help is appreciated. I can also send by e-mail a test .4gl for > this (bug in my opinion). > > Thanks > Panos Hi Panos, for all I know the number of lines in the FIRST PAGE HEADER clause must match the number of lines in the PAGE HEADER clause. If you try to translate a report file with "saceprep" where the number of lines does not match, the compiler would issue an error. I wonder why your 4GL compiler does not produce an error. Best regards, Stefan stefan@weideneder.de