<div>
A minor correction:<br />
<br />
SYSTEM.TRIGGER_RECORD<br />
<br />
should be <br />
<br />
:SYSTEM.TRIGGER_RECORD<br />

</div>


A minor correction:

SYSTEM.TRIGGER_RECORD

should be

:SYSTEM.TRIGGER_RECORD


<div>
What is the difference between set_item_property and set_item_instance_property<wbr />? I tried using set_item_property in the post query trigger but it didn't work. i.e. it was still allowing update of the item. However, when I placed the set_item_property in the when-new-record-instance trigger, then it worked. I also set one of the form item's update_not_allowed property to false at the pre-form level as I do not want any user to enter a value in that form item. It works for records with values in it but &nbsp;it will not work for new records, i.e. for a new (blank) record. How can I set update_not_allowed for that item for a new record?
</div>


What is the difference between set_item_property and set_item_instance_property? I tried using set_item_property in the post query trigger but it didn't work. i.e. it was still allowing update of the item. However, when I placed the set_item_property in the when-new-record-instance trigger, then it worked. I also set one of the form item's update_not_allowed property to false at the pre-form level as I do not want any user to enter a value in that form item. It works for records with values in it but  it will not work for new records, i.e. for a new (blank) record. How can I set update_not_allowed for that item for a new record?

<div>
Never mind about the last part. I forgot I can set the property for the item in the property palette to insert and update not allowed.
</div>


Never mind about the last part. I forgot I can set the property for the item in the property palette to insert and update not allowed.

<div>
<div class="content wysiwyg-content">
I wish to set the update allowed property for one of the form &nbsp;items on my form to false &nbsp;(code item) if &nbsp;the value of another form item (type) is 'F' when the values are loaded from the record into the form. Where should I write this trigger? Would it be at the post-query block level ?
</div>
</div>


I wish to set the update allowed property for one of the form  items on my form to false  (code item) if  the value of another form item (type) is 'F' when the values are loaded from the record into the form. Where should I write this trigger? Would it be at the post-query block level ?

Where can I set the updateable property for a form item?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.