Looping through records
723680Oct 29 2009 — edited Oct 29 2009Hi,
I am required to loop through records that are populated in a tabular block whenever a checkbox is checked/unchecked. I am using the following code to achieve the same.
x=current_record;
go_block(block_name);
FIRST_RECORD;
loop
<<SOME_ACTION>>
exit when :SYSTEM.LAST_RECORD = 'TRUE';
NEXT_RECORD;
end loop;
go_record(x)
The problem is that though after the looping I go back to the record where the loop was called, the record becomes the first visible row in the grid.
For e.x. if called from the second row where first row is still visible in the screen, after the function is called the table scrolls and cursor is set to the 2nd row.
Hiw can this be avoided.
Regards
Deepak