Re: ORDER BY statement inside a REPORT
Stefan Weideneder wrote: > > 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. > > 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. Not true. FIRST PAGE HEADER can have a different number of lines from the PAGE HEADER. No error will result, on any version. I didn't see the original post, but judging by the included text, this is describing a bug that appeared round about 4.14 or something. The PAGENO was not calculated correctly resulting in no page throw being made. Have you checked with Informix for known problems? Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+