Home » Developer & Programmer » Forms » record group Looping
record group Looping [message #240020] Wed, 23 May 2007 23:06 Go to next message
u263066
Messages: 47
Registered: March 2007
Member
When button is pressed , I am builting a record group for those record which checkbox checked.

Data in tabular form, and checked value is Y and unchecked is N.
Where xx_aa.create_populate_rec_group is the procedure in which I am keep adding of column.

Can any one advice where its goes wrong.

Right now, when i am pressing the button, it get hanged

here is code
BEGIN
FIRST_RECORD;
LOOP
if (:INVOICE_HEADER.REPROCESS_CHECKBOX) = 'Y' THEN
	xx_aa.create_populate_rec_group(:INVOICE_HEADER.TRX_ID);
EXIT 
WHEN :SYSTEM.LAST_RECORD = 'TRUE';
NEXT_RECORD;
END IF;
END LOOP;
END;
Re: record group Looping [message #240082 is a reply to message #240020] Thu, 24 May 2007 01:44 Go to previous message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Infinite loop, I'm afraid.

First record's REPROCESS_CHECKBOX value is not 'Y', so the whole IF is skipped; the next statement is END LOOP which returns you back to IF, but - as you are still on the first record, IF is false again and you're back on END LOOP which returns you to IF on the first record etc. etc.

Fix it.
Previous Topic: Single executable from oracle forms/On-Logon
Next Topic: Logic Required to Slove
Goto Forum:
  


Current Time: Mon Dec 05 05:01:26 CST 2016

Total time taken to generate the page: 0.09385 seconds