Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamically set the Return Item property of the LOV

710510Apr 23 2011 — edited Apr 24 2011
Good day to you ...
I was trying to hide and re-hide a text item ... this text item has a LOV associated with it.
I successfully enabled it ... using the following :
SET_ITEM_PROPERTY('TEXT_ITEM', VISIBLE , PROPERTY_TRUE );
SET_ITEM_PROPERTY('TEXT_ITEM', ENABLED , PROPERTY_TRUE );
*SET_ITEM_PROPERTY('TEXT_ITEM', NAVIGABLE , PROPERTY_TRUE ); --property Not found in forms builder help*
*SET_ITEM_PROPERTY('TEXT_ITEM', UPDATEABLE , PROPERTY_TRUE ); --property Not found in forms builder help*
*SET_ITEM_PROPERTY('TEXT_ITEM', QUERYABLE , PROPERTY_TRUE ); --property Not found in forms builder help*
SET_ITEM_PROPERTY('TEXT_ITEM', LOV_NAME ,'LOV_NAME' ); -- LOV associated in design has been removed when item has got hidden

But I couldn't dynamically set the Return Item property of the LOV .. cause when running the form ... LOV appears with no return items (they exist in design of LOV but have been removed when item has got hidden).
I searched for SET_LOV_PROPERTY properties and never found it , although a property like COLUMN_NAME exists , but never found in forms builder help .
I need a list of available properties for SET_LOV_PROPERTY to set the Return Item property of the LOV
**Thanks **
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2011
Added on Apr 23 2011
3 comments
1,320 views