| need help in calculation [message #78930] |
Tue, 02 April 2002 21:40  |
annu
Messages: 34
Registered: February 2002
|
Member |
|
|
dear experts ,,,
i m working on tabular form and i have three feilds on it like qty, rate and amount. I set the calculation property of amount column to formula and write a formula :qty*:rate .. it works and give me a calculated result of each row but .. it doesnot save the date in this column of table .. whicle the property of formula column is display item.
Annu
|
|
|
|
| Re: need help in calculation [message #78952 is a reply to message #78930] |
Fri, 05 April 2002 19:38  |
rama krishna
Messages: 97
Registered: December 2001
|
Member |
|
|
if u set the calculation property of an item then it will be only only used for display, and it will not get inserted into the database (this is my personal experience). what u can better do is use it for display at the front-end and write a back-end trigger which will fire for each row and calculate the total and put it in the total column.....
hope this'll work for u....
cheers
ram
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
