This topic is locked

Derived Fields

4/19/2007 10:12:53 AM
PHPRunner General questions
D
dcrera author

Hi,
This might be a dumb question but I need to ask anyway.
How do I include Derived Fields (derived from one or more source fields) in my form ?
Eg. Qty * Price = Value
I want a field to display the value (non database field).
Thanks

Sergey Kornilov admin 4/19/2007

Modify SQL query for this purpose:

select field1,

field2,

...,

Qty * Price as Value

from ...


Check SQL Query guidelines for more info.