FW:

I received following mail from Rekaish. I hope his idea will be worth for some one else. Or maybe is there any body interested in debugging the error ? :-) I have sent the code to Rekaish. Thank you very much Rekaish. -- garnadi > -----Original Message----- > From: Rekaish Bhardwaj [mailto:RekaishB@compans.com] > > Do you have an order by .... statement in the REPORT block of code. > > I suspect the report is ordering the data . You will not > normally get the > required results until > all the data has been passed to the report. > > send me the whole code. > > > Rekaish Bhardwaj > Computer Answers International Limited > 9 The Courtyard > Warwick Road > Solihull > West Midlands B91 3DA > United Kingdom > > Tel: +44 (0) 121 703 0300 > Fax +44 (0) 121 703 0399 > Mobile: +44 (0) 498 765424 > Email: rekaishb@compans.com > > > > -----Original Message----- > > From: Garnadi [SMTP:garnadi@kpei.co.id] > > > > Hello, > > > > I have codes like followwing : > > > > > > ========================== > > this block is in the main block > > DEFINE var1 integer > > > > FOREACH k2r42_02_curs INTO pr_gagal.* > > LET var1= pr_gagal.var1 > > MESSAGE "This is for each ", var1 > > # line 1 > > OUTPUT TO REPORT k2r42_01r(pr_gagal.*) > > MESSAGE "This is after OUTPUT TO REPORT" > > # line 2 > > END FOREACH > > > > this one is in the k2r42_01r function block > > PAGE HEADER > > MESSAGE "This is page header section", var1 > > #line 3 > > > > ON EVERY ROW > > ... > > ========================== > > > > > > When I execute those codes, the output is strange (to me :-)) > > * line 1 and line 2 are printed and printed as many as > row count but > > line > > 3 is never until all the record are fetched > > * after this (all record are fetched) line 3 is printed > and printed as > > many as number of pages > > and var1 in the line 3 is always same, i.e. last > assignment in FOREACH > > > > I have many other similar codes, but all work well except > one, only one. > > > > Could you understand what I mean ? > > If so, is there any mistake I made ? > > > > > > Thanks in advance, > > > > > > -- garnadi