Home » Developer & Programmer » Forms » Help: Need to set Update Allowed property
Help: Need to set Update Allowed property [message #274039] Fri, 12 October 2007 19:38 Go to next message
Messages: 1
Registered: October 2007
Junior Member
Hello everyone! Im new to oracle so please bare with me. I wish to consult my problem.

Scenario :

I have two forms, Form A and Form B. They both can be called from the menu but Form B can also be called from a button in Form A. I am passing global variable (Account_no) as I call form B from Form A and then catch all of it in when-new-form instance of Form B. The global variable are then assigned to a field in Form B (Account_no field).


When I call Form B using Form A's button, I would want the first field which is Account_no field to be unupdateable. So in Form B When-new-instance trigger, Im trying to set it using set_item_property('BLK.account_no', UPDATE_ALLOWED, property_false); . But it doesnt seem to work, the value can be updated/modified. REading the Online help tells me that update_allowed property wont work if the status is in New and Insert. Sad I also tried to place it in the pre-text-item trigger of the field but still having the same result.

Could you please give me advise or tips on how to handle it. I really need it badly.

Thanks in advance.

[Updated on: Fri, 12 October 2007 19:41]

Report message to a moderator

Re: Help: Need to set Update Allowed property [message #274055 is a reply to message #274039] Sat, 13 October 2007 02:59 Go to previous messageGo to next message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, if :global.account_no exists, you are going to use its value in FORM_B.block_name.account_no item, and don't want to allow anyone to change its value. Right?

If so, it means that you, actually, don't want to do anything with this item. Therefore, perhaps you might disable it (using the ENABLED property and setting it to FALSE).
Re: Help: Need to set Update Allowed property [message #274173 is a reply to message #274039] Sun, 14 October 2007 21:29 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You can't disable the field which is currently the 'focus' of your form. Either, in your when-new-form-instance trigger move the focus to another field before disabling this special field, or in the definition of your block define a field other than your special field as being the first field.

Previous Topic: Display item in forms
Next Topic: how can i send print command from form to printer?
Goto Forum:

Current Time: Fri Jul 21 00:10:13 CDT 2017

Total time taken to generate the page: 0.23052 seconds