I have item named (ON_HAND_QTY) and i want to do a certain action whenever the value changed in this item what i need something like this :old_value and :new_value or something similar to this logic.
Question
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
I have item named (ON_HAND_QTY) and i want to do a certain action whenever the value changed in this item what i need something like this :old_value and :new_value or something similar to this logic.
to get the database value there is one property (database_value) and here is the example to achieve this:
[code]
BEGIN
IF :BLOCK.ITEM = GET_ITEM_PROPERTY(‘BLOCK.ITEM’, database_value) THEN
RETURN;
END IF;
END;
[/code]
sometimes this property return value (0) if so you can use another way :
-take the value in the pre text item trigger and keep it in global
– as about this value in when validate item trigger and so on
hope this may help you 🙂