OraFAQ Forum: Forms » How to go through all items in the form ???

Home » Developer & Programmer » Forms » How to go through all items in the form ???

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

How to go through all items in the form ??? [message #464083]

Tue, 06 July 2010 03:58

FOX_55
Messages: 14
Registered: June 2010

Junior Member

hey
is there any way or loop to go through all items in a form
and check them with a condition ???

Report message to a moderator

Re: How to go through all items in the form ??? [message #464088 is a reply to message #464083]

Tue, 06 July 2010 04:13

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Pseduo code:

first_record
LOOP
<do_stuff>
EXIT WHEN :system.last_record = 'TRUE';
next_record;
END LOOP;

Report message to a moderator

Re: How to go through all items in the form ??? [message #464102 is a reply to message #464088]

Tue, 06 July 2010 04:37

FOX_55
Messages: 14
Registered: June 2010

Junior Member

i need the item it self
not what inside it

i want to make a procedure to change all prompt name of all item to another name
so i have to go through all items and check the name and compare it with the data in data base and put the new name

Report message to a moderator

Re: How to go through all items in the form ??? [message #464121 is a reply to message #464102]

Tue, 06 July 2010 06:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

See Forms' System variables; :system.cursor_item or :system.trigger_item might be what you are looking for. SET_ITEM_PROPERTY built-in with its PROPERTY_TEXT will be used to set item's prompt.

Report message to a moderator

Re: How to go through all items in the form ??? [message #465388 is a reply to message #464121]

Wed, 14 July 2010 01:14

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

Senior Member
Account Moderator

Have you solved your problem?

Do you want to do this just once or everytime that the Form is used? If the latter, then use the 'get_block_property(first_item)' and 'get_item_property(nextitem)' or 'get_item_property(next_navigation_item)' until you reach the item specified in 'get_block_property(last_item)'.

David

Report message to a moderator

Re: How to go through all items in the form ??? [message #465400 is a reply to message #465388]

Wed, 14 July 2010 01:39

FOX_55
Messages: 14
Registered: June 2010

Junior Member

i solve this problem
and i was using the same functions that u suggested me to use
thx a lot

Report message to a moderator

Previous Topic:	How to handle Tlist
Next Topic:	Printing Double-Sided using SET_REPORT_OBJECT_PROPERTY

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 21:51:35 CST 2025