Home » Developer & Programmer » Forms » need help in calculation
need help in calculation [message #78930] Tue, 02 April 2002 21:40 Go to next message
Messages: 34
Registered: February 2002
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.

Re: need help in calculation [message #78952 is a reply to message #78930] Fri, 05 April 2002 19:38 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
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....

Previous Topic: D2K form design issue
Next Topic: Help Need In Query
Goto Forum:

Current Time: Sat Jul 04 02:01:38 CDT 2020