Home » Developer & Programmer » Forms » How to make a field not updatable(update_allowed property) (Oracle forms 6i)
How to make a field not updatable(update_allowed property) [message #411144] Thu, 02 July 2009 03:01 Go to next message
shyamxtasy
Messages: 1
Registered: July 2009
Junior Member
Hi

There are two fields Refund type and refund amount

If refund type is F
refund amount type is not navigable
If refund type is P
refund amount is navigable and can be updated. Below is the code

POST-ITEM-TRIGGER
IF :refund_type = 'P' THEN
SET_ITEM_PROPERTY('refund_amount',UPDATE_ALLOWED,PROPERTY_TRUE);
SET_ITEM_PROPERTY('refund_amount',NAVIGABLE,PROPERTY_TRUE);
ELSE
SET_ITEM_PROPERTY('refund_amount',UPDATE_ALLOWED,PROPERTY_FALSE);
SET_ITEM_PROPERTY('refund_amount',NAVIGABLE,PROPERTY_FALSE);
END IF;

Note: Update allowed property of the field refund amount is set NO in the field properties

Now i want to make refund amount is navigable and should not be updated. If user trying to update it should shout FIELD IS PROTECTED AGAINST UPDATE.

Can anyone help me in this...please

Regards,
Jairam

[Updated on: Thu, 02 July 2009 05:59]

Report message to a moderator

Re: How to make a field not updatable(update_allowed property) [message #411191 is a reply to message #411144] Thu, 02 July 2009 06:33 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid that I don't quite understand the question. It appears that you know how to use SET_ITEM_PROPERTY, but
Now i want to make refund amount is navigable and should not be updated.
sounds as if one should use
navigable -> property_true
update_allowed -> property_false

So where's the problem? What does "now I want ..." mean? What is "now"?
Previous Topic: Continue statement
Next Topic: stop detail block from executing
Goto Forum:
  


Current Time: Fri Sep 20 13:40:11 CDT 2024