 update allowed (NO) feild [message #140427] |
Tue, 04 October 2005 03:32  |
mishm3gool
Messages: 5
Registered: October 2005
Location: Jordan
|
Junior Member |
|
|
i have a feild that it's property "UPDATE ALLOWED" set to "NO" ,
but it can be changed via a LOV related to it.
how can i prevent this feild from being updated although it has a list of value LOV related to it ?????????????????????????????
thanx a lot for your cooperation
Best regards
|
|
|
|
| Re: update allowed (NO) feild [message #140597 is a reply to message #140427] |
Tue, 04 October 2005 19:28  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
There are a number of alternatives:
- remove the LOV (set_item_property(LOV_NAME) to NULL).
- disable the item (set_item_property, or set_item_instance_property)
- set NAVIGABLE and MOUSE_NAVIGATE to PROPERTY_FALSE (set_item_property)
- in the When-New-Item-Instance trigger test your settings and if necessary do an immediate Next_Item command.
Looking at it another way, if you WANT them to see the LOV, as you have multiple columns in the LOV that give extra information, in a Key-Listval trigger, store the current value, do the Show_LOV, and if the returned value is different to the original value then you may show an alert, a message, or simply return the original value and do a raise form_trigger_failure to stop field validation from firing.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
