Calculated Fields... Question/Problem when updating..
Posted: Mon Sep 08, 2003 10:04 pm
Hi..
I was wondering how do you update a calculated field in mysql? Using mysql? Are there any functions that could help you? Or do I have to create one?
Can anyone help?
I couldn't find much so far that could help me with this
any comments/ help.. is appreciated
Thanks alot!
I was wondering how do you update a calculated field in mysql? Using mysql? Are there any functions that could help you? Or do I have to create one?
Code: Select all
eg:
field 1 value: 10
field 2 value: 5
field 3 value: 15 (field 1 + field 2)
then when i update and change field 2.. value: 8
I would like field 3's value to change..
So now field 3 value should be: 18any comments/ help.. is appreciated
Thanks alot!