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.