OraFAQ Forum: Forms » first_record loop through an LOV

Home » Developer & Programmer » Forms » first_record loop through an LOV

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

first_record loop through an LOV [message #195226]

Wed, 27 September 2006 08:20

ChrisCash
Messages: 2
Registered: September 2006

Junior Member

I have a multi-block form with master-detail relationships. A unique value (contract_no) is called via a LOV which populates the various other blocks. Within this form I have a push button that runs a calculation and populates a new table with the results based on the unique contract_no that is passed in by the LOV.

This works fine for the individual records but what I need to do is to perform the calculation for every contract_no within the contracts table in one loop.

I have written the following code behind a new push button. I think the problem is that this wont work because as the contract_no is unique (which is passed in by the LOV) the first and last record will be the same because the form only sees the unique contract_no.

first_record;
LOOP
--do the calculations here
IF (:system.Last_record = 'TRUE') THEN
EXIT;
ELSE next_record;
END IF;
END LOOP;
COMMIT;

Hope this makes some sense,
Any help would be great

Report message to a moderator