2. PHPRunner General questions
  3. update calculated column
This topic is locked

update calculated column

 		2/17/2005 11:50:22 AM
PHPRunner General questions
author

if I query: "time * hour as Total" from tabel
Is it possible to update the calculated column "total" ?

so that the database gets this value in a column "Total" and can be used for other calculations?

[email=Braam.a@chello.nl]Braam.a@chello.nl[/email]
500180 2/17/2005

I second this because right now my customer has to re-enter thier information in a second column "subtotal2" so the Total can be recalculated.
Thanks,

sjnkns
Sergey Kornilov admin 2/22/2005

You cannot update a column that don't exists. Calculated columns are updated automatically when you change columns that participate in calculation (columns time and hour in your example).