Home » Developer & Programmer » Forms » Formula Field and Triggers
Formula Field and Triggers [message #85746] Mon, 26 July 2004 11:40 Go to next message
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

Report message to a moderator

Re: Formula Field and Triggers [message #85749 is a reply to message #85746] Mon, 26 July 2004 20:40 Go to previous message
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

Report message to a moderator

Previous Topic: sequence in which triggers are executed
Next Topic: Running Forms from Explorer
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 22:05:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.