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 to be used for only few records.

_JC_Feb 5 2016 — edited Feb 6 2016

Hi Guys,

I am using a loop to fill in values in rows in BLK_SEL_ASSESSORS Block.

Based on status from I need to either enable or disable the insert on ASSESSOR field.

here is my part of code

FOR i IN c_task

LOOP

....

...

IF UPPER(i.taskstatus) = 'COMPLETED' THEN

                    SET_ITEM_PROPERTY('BLK_SEL_ASSESSORS.ASSESSOR',INSERT_ALLOWED,PROPERTY_FALSE);

      ELSE

                    SET_ITEM_PROPERTY('BLK_SEL_ASSESSORS.ASSESSOR',INSERT_ALLOWED,PROPERTY_TRUE);

END IF;

NEXT_RECORD;

END LOOP;

But I noticed that the line

SET_ITEM_PROPERTY('BLK_SEL_ASSESSORS.ASSESSOR',INSERT_ALLOWED,PROPERTY_TRUE);

Is having the effect on all the rows in the block.

All i want is that the field ASSESSOR should be enabled for insert for the rows where status is not complete and to be disabled for insert where status is complete.

Please help me out.

This post has been answered by HamidHelal on Feb 5 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2016
Added on Feb 5 2016
4 comments
5,975 views