Home » D2k » Moving From Top To Bottom in Detailed Block in Oracle Forms

Moving From Top To Bottom in Detailed Block in Oracle Forms

Suppose you want to scan a tabular grid block (loop through all records in detail block) from top to bottom in Oracle forms. You can do this task by using :system.last_record system variable to determine whether it is last record in a block and then exit.
Example:
Begin
   go_block('yourblock');
   --- then move to first record
   first_record;
   Loop
      --- do some processing
      null;
      if :system.last_record = 'TRUE' then
         exit;
      End if;
      next_record;
   End Loop;
   --- after exiting move to top
   first_record;
End;

1 thought on “Moving From Top To Bottom in Detailed Block in Oracle Forms”

Comments are closed.