|
Re: set item property like this [message #576319 is a reply to message #576316] |
Sun, 03 February 2013 04:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I'm afraid I don't understand the question. What does Quote:
I am forced to close insert and update on master black mean? ("black" is "block", I suppose, but - "forced to close ..."?!?)
The rest of it: if STATE = 40 then some other field should be changed to - what? Try with WHEN-VALIDATE-ITEM when inserting/updating values; put the same code into POST-QUERY block-level trigger while selecting existing values.
If that's not what you are looking for, please, try to describe the problem once again (you could even post a screenshot of your form; if you do that, please, take only important part of the form, not the whole screen along with Windows background and stuff; also, save it as a JPG or PNG).
|
|
|
Re: set item property like this [message #576325 is a reply to message #576319] |
Sun, 03 February 2013 06:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/72904f34fb55c15f937203f026b1a631?s=64&d=mm&r=g) |
n.shahab
Messages: 3 Registered: February 2013
|
Junior Member |
|
|
I in Trigger when new record instance
I've written
IF (:SLT_TYP_STA > 20) THEN
SET_BLOCK_PROPERTY('SLT',UPDATE_ALLOWED, PROPERTY_FALSE) ;
SET_BLOCK_PROPERTY('SLS',INSERT_ALLOWED, PROPERTY_FALSE) ;
SET_BLOCK_PROPERTY('SLS',UPDATE_ALLOWED, PROPERTY_FALSE) ;
SET_BLOCK_PROPERTY('SLS',DELETE_ALLOWED, PROPERTY_FALSE) ;
ELSE
SET_BLOCK_PROPERTY('SLT',UPDATE_ALLOWED, PROPERTY_TRUE) ;
SET_BLOCK_PROPERTY('SLS',INSERT_ALLOWED, PROPERTY_TRUE) ;
SET_BLOCK_PROPERTY('SLS',UPDATE_ALLOWED, PROPERTY_TRUE) ;
SET_BLOCK_PROPERTY('SLS',DELETE_ALLOWED, PROPERTY_TRUE) ;
END IF;
Here is my question
i have to changed the second field in slt block
In Status following
:slt.SLT_TYP_STA = 50
But the block is closed
I'm sorry my language is not so good
I have noticed
Thank you
|
|
|
|