| record group Looping [message #240020] |
Wed, 23 May 2007 23:06  |
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  |
 |
Littlefoot
Messages: 21818
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
