| Formula Field and Triggers [message #85746] |
Mon, 26 July 2004 11:40  |
Rick
Messages: 49
Registered: March 2000
|
Member |
|
|
In forms 6i I have a field that is a formula to calculate the value, what I need to do is that when this value changes to execute a program unit. Since the cursor is never in this field, can I assign a trigger to this field to monitor it for changes to execute the program unit code? If so, which one?
Thanks
Rick
|
|
|
|
| Re: Formula Field and Triggers [message #85749 is a reply to message #85746] |
Mon, 26 July 2004 20:40  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Create a control item which has the initial value of your formula column.
Create a repeating timer.
The timer will keep on checking if the value of your Formula column=Control column.
If not execute procedure.Set the value of Control column as Formula column,reset the timer.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
