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!

obtaining item record instance values without navigating

2822481Aug 15 2007 — edited Aug 17 2007
Is it possible to obtain the value in, say, a text item for a specific instance/record without going to that instance record.

Normally any reference to an item value will use the current/cursor record
i.e. myvar := :block.text_item;

but in a multi-record block you would have to go_item/go_record first before using this code:
i.e. go_item(''block.text_item');
go_record(3);
myvar := :block.text_item;

However, is it possible to do something like:

myvar := get_item_instance_property('block.text_item',<record_number>,value);
(NB: I know the above is not possible)

Many thanks

ps: the reason i ask is because i need to perform some complex validation and would like to do it via a pre-commit trigger (which does not allow navigation)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2007
Added on Aug 15 2007
8 comments
636 views