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!

Set Item Property in Detail Block

746063Jan 12 2010 — edited Jan 13 2010
Hello,

I would like to set an item property in my detail block which consists of multiple records like a tabular form. For example, when I use APIs like the code below. The APIs set the whole column for this particular item instead of set each item in each record. Could you please have a look the coding below and advise how I can set each item in each record?


-----------------------------------------------------------------------
BEGIN


GO_BLOCK('USER_RESP');

last_record;
first_record;
LOOP

if :USER_RESP.END_DATE is null then
--app_item_property.set_property('USER_RESP.END_DATE', ALTERABLE_PLUS,PROPERTY_OFF);
set_item_property('USER_RESP.END_DATE', INSERT_ALLOWED,PROPERTY_OFF);
set_item_property('USER_RESP.END_DATE', UPDATE_ALLOWED,PROPERTY_OFF);
end if;

exit when :system.last_record = 'TRUE';
next_record;
END LOOP;
first_record;




END;

--------------------------------------------------------------------------------

Edited by: user11270809 on Jan 12, 2010 6:15 PM
This post has been answered by 725341 on Jan 13 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2010
Added on Jan 12 2010
4 comments
3,434 views