haci aliyev haci aliyev - 2 years ago 170
SQL Question

How can I calculate sql tables in delphi ?

Hi I have sql table I want to calculate all the fields to total sum field.
enter image description here

Answer Source

You can do this in the SELECT statement you use to get the data, something like

SELECT *, big1 + small1 as "TotalSum"

Obviously, you can add more numeric fields to the fields to sum.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download