We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

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

geeta_m9
geeta_m9 asked
on
Medium Priority
730 Views
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 ?
Comment
Watch Question

Database Administrator
CERTIFIED EXPERT
Commented:
POST Query:

If BLOCK_NAME.item1  = 'F' then
SET_ITEM_INSTANCE_PROPERTY('BLOCK_NAME.ITEM_NAME',     SYSTEM.TRIGGER_RECORD,UPDATE_ALLOWED ,property_false);
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Ora_TechieDatabase Administrator
CERTIFIED EXPERT

Commented:
A minor correction:

SYSTEM.TRIGGER_RECORD

should be

:SYSTEM.TRIGGER_RECORD

Author

Commented:
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

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.