OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Iterate

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

Iterate [message #145727]

Sat, 05 November 2005 07:22

Shaila.Mehra
Messages: 88
Registered: July 2005
Location: mumbai

Member

Hi to all....

How do i use this code to iterate the record.
In which trigger i use this.

OriPos := TO_NUMBER(:System.Trigger_Record);
First_Record;
LOOP
  --   do processing
  IF (:System.Last_Record = 'TRUE') THEN
     Go_Record(OriPos);
     EXIT;
  ELSE
     Next_Record;
  END IF;
END LOOP

Shaila.

Upd-mod: Add code tags

[Updated on: Sun, 06 November 2005 19:23] by Moderator

Report message to a moderator

Re: Iterate [message #145789 is a reply to message #145727]

Sun, 06 November 2005 19:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

The 'Next_Record' and the 'Loop' ARE the iteration.

I would normally use this type of 'block scan' in a When-Button-Pressed trigger.

David

Report message to a moderator

Previous Topic:	Forms 6i default text field height
Next Topic:	Unable to execute Forms (Internet Explorer: "Page not found")

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 20 06:01:12 CDT 2026