Home » Developer & Programmer » Forms » set item property like this
icon9.gif  set item property like this [message #576316] Sun, 03 February 2013 04:29 Go to next message
n.shahab
Messages: 3
Registered: February 2013
Junior Member

Hi everyone
I recently became a member here
I am forced to close insert and update on master black then
In a particular situation for example state=40
i Should
changed the second field in same block

I do not know how to do it
Please help me it is very important to me
Re: set item property like this [message #576319 is a reply to message #576316] Sun, 03 February 2013 04:58 Go to previous messageGo to next message
Littlefoot
Messages: 19474
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 messageGo to next message
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
Re: set item property like this [message #576338 is a reply to message #576325] Sun, 03 February 2013 09:29 Go to previous message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Obviously, if you set all properties to FALSE, you can't expect that updating will work. First modify properties, then do the update.
Previous Topic: Disable save button after saving
Next Topic: Error when run report
Goto Forum:
  


Current Time: Thu Aug 21 15:42:55 CDT 2014

Total time taken to generate the page: 0.24710 seconds