Posting from the Informix-list
Posted in 1999
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