SET_ITEM_PROPERTY('DYNAMIC ITEM ID',PROPERTY,VALUE)

Hi all .
Is it possible to pass the Item_id dynamically to the SET_ITEM_PROPERTY?

normally we pass it like SET_ITEM_PROPERTY('Item_id',property,value);
item_id is within single quotes ('item_id')
but if we pass some variable say 'M_DAY' which will have item_id's, will it work. I didn't try it yet. Thought i could get some feedback here before proceeding. any example will higly appriciated


Thanks in Advance
HIna mansoor
hinamansoorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alex [***Alex140181***]Software DeveloperCommented:
Search the help manuals (F1 in Forms Developer) for the built-in function "NAME_IN". It should be and do exactly what you arre looking for...
Mark GeerlingsDatabase AdministratorCommented:
That is correct.  To do this dynamically in Oracle Forms, you need to use the "name_in" built-in function.
hinamansoorAuthor Commented:
Sir any short example of  "NAME_IN" built_in function




Thanks
Hina mansoor
Alex [***Alex140181***]Software DeveloperCommented:
set_item_property (name_in('system.cursor_item'), VISUAL_ATTRIBUTE, 'some_vis_attr');

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hinamansoorAuthor Commented:
Thanks @Alex140181 that was really useful example




Hina mansoor
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.