How to locate a specified record?

[roseMay]

I am using Oracle Forms 6i...

I have a block including lots of records sorted by date column, assume that I have the detail of a specified record, how could I locate and let the cursor stay in that record? Which built-in can I use?

 

[BJCooperIT]

first_record;
<<SEARCH>>
if ...some mandatory field... is null then --Past last row
   first_record;                           --No match
else
   if ...record not a match... then
      next_record;
      goto SEARCH;
   end if;
end if;

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus