| How to recalculate record [message #136494] |
Thu, 08 September 2005 05:53  |
Man Mohan Sharma
Messages: 35
Registered: October 2003
|
Member |
|
|
I have a detail block where so many rows presents i have written a POST_TEXT_ITEM trigger on a column that do some calculation on slected number of rows given in the that field. If I change amount field in the diffrrent record then I have to go that field to excute POST_TEXT_ITEM trigger.
Is there any way to refresh my calculation
|
|
|
|
| Re: How to recalculate record [message #136587 is a reply to message #136494] |
Thu, 08 September 2005 19:00  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Suggestion: Put code into a form procedure. For each field that can be changed and is part of the calculation, create a When-Validate-Item trigger for it, and call the procedure to update the 'result' field.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
