CODEWITHSUNDEEP
oracle-databaseoracle11goracleforms
User10120
User10120

Reputation: 1

In multi record form how to set focus on 5th record when new form instance in Oracle forms 10g

In Oracle 10g forms developer i have 2 forms one is search form another is details.details form is multi record form.wgen details form opens cursor points to first record by default.(out of 10 records in forms).we have a requirement where if TRX number in search form on populate details if is on position 5th in details form then cursor should point to 5th position record.how to implement this?

Upvotes: 0

Views: 435

Answers (1)

Littlefoot
Littlefoot

Reputation: 142958

I don't know what "TRX number" is, but - a simple option is to use a built-in procedure:

go_block('your_detail_block');
go_record(:trx_number_field);

Another option is to use a loop:

go_block('your_detail_block');
for i in 1 .. :trx_number_field loop
  next_record;
end loop;

Upvotes: 1

Related Questions