this is non-sense (calculated field) [message #112244] |
Wed, 23 March 2005 20:00 |
sshan
Messages: 19 Registered: March 2005
|
Junior Member |
|
|
I have a calculated field called VOL, which is calculated from the other three fields(height, width, and depth).
I assigned the formula:
:height * :width * :depth
which comes out a right number.
HOWEVER, after I save the record, the calculation was not saved to the table.
I understand the value might just for DISPLAY. but, where should I change in order to be able to save it. I have carefully gone through every attribute in property, but failed to find out.
Doea anyone know?
Thanks,
|
|
|
|
|
Re: this is non-sense (calculated field) [message #112316 is a reply to message #112244] |
Thu, 24 March 2005 06:53 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
sshan wrote on Thu, 24 March 2005 03:00 | I have a calculated field called VOL, which is calculated from the other three fields(height, width, and depth).
| And the field is being calculated when exactly? Post-query? view definition?
sshan wrote on Thu, 24 March 2005 03:00 | HOWEVER, after I save the record, the calculation was not saved to the table.
| And the field is a database item?
sshan wrote on Thu, 24 March 2005 03:00 | I understand the value might just for DISPLAY. but, where should I change in order to be able to save it. I have carefully gone through every attribute in property, but failed to find out.
|
Is it really necessary to save the calculation? If so, verify that there's a table column corresponding with your block's item. Set the property database item to 'Yes'.
MHE
|
|
|