Solved

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

Posted on 2013-12-25
5
2,338 Views
Last Modified: 2013-12-27
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
0
Comment
Question by:hinamansoor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 39739363
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...
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 39740643
That is correct.  To do this dynamically in Oracle Forms, you need to use the "name_in" built-in function.
0
 

Author Comment

by:hinamansoor
ID: 39741679
Sir any short example of  "NAME_IN" built_in function




Thanks
Hina mansoor
0
 
LVL 13

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 500 total points
ID: 39741686
set_item_property (name_in('system.cursor_item'), VISUAL_ATTRIBUTE, 'some_vis_attr');

Open in new window

0
 

Author Comment

by:hinamansoor
ID: 39741937
Thanks @Alex140181 that was really useful example




Hina mansoor
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question