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

Posted on 2006-04-04
Last Modified: 2012-06-27
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 ?
Question by:geeta_m9
    LVL 13

    Accepted Solution

    POST Query:

    If BLOCK_NAME.item1  = 'F' then
    END IF;

    I supposed you want to set updateable property of BLOCK_NAME.ITEM_NAME on the basis of value of item BLOCK_NAME.item1. You will have to replace items names and block name.
    LVL 13

    Expert Comment

    A minor correction:


    should be


    Author Comment

    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?

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now