Looping(all blocks, all records, all items) multi and single record blocks) will this work?
From: steve deno <sldcrew2k_at_yahoo.com>
Date: 5 Jun 2003 13:49:03 -0700
Message-ID: <8e6b14d8.0306051249.6ef16ddd_at_posting.google.com>
[Quoted] Hi all,
[Quoted] WHILE :SYSTEM.last_record != 'TRUE'LOOP--RECORD--
END LOOP;--RECORD--
Date: 5 Jun 2003 13:49:03 -0700
Message-ID: <8e6b14d8.0306051249.6ef16ddd_at_posting.google.com>
[Quoted] Hi all,
I am trying to loop through all records in all blocks and hit all items, to check their values/properties. I have a procedure and it ALMOST seems to work in the following code. However, I think that the fact of where I am navigating at which time is causing an issue. the result is that I hit all blocks andd items but not all records in multi-record blocks. to start, I see in the debugger that [Quoted] :SYSTEM.last_record has no value. Is this my problem? All help is appreciated. Thanks very much
BEGIN
cur_frm := :SYSTEM.Current_Form; cur_blk := Get_Form_Property(cur_frm,FIRST_BLOCK); lst_blk := Get_Form_Property(cur_frm,LAST_BLOCK); cur_itm := cur_blk||'.'||Get_Block_Property(cur_blk,FIRST_ITEM); lst_itm := cur_blk||'.'||Get_Block_Property(cur_blk,LAST_ITEM); WHILE cur_blk <> lst_blk LOOP--BLOCK--First_Record;
[Quoted] WHILE :SYSTEM.last_record != 'TRUE'LOOP--RECORD--
WHILE cur_itm <> lst_itm LOOP--ITEM -- My code to be run on every item of every record of every block in my form cur_itm := cur_blk||'.'||GET_ITEM_PROPERTY(cur_itm, NEXTITEM); END LOOP;--ITEM -- NEXT_RECORD;
END LOOP;--RECORD--
cur_blk := GET_BLOCK_PROPERTY(cur_blk, NEXTBLOCK); cur_itm := cur_blk||'.'||Get_Block_Property(cur_blk,FIRST_ITEM); lst_itm := cur_blk||'.'||Get_Block_Property(cur_blk,LAST_ITEM);END LOOP;--BLOCK-- END; Received on Thu Jun 05 2003 - 22:49:03 CEST