How can I calculate sql tables in delphi ?

Question

Hi I have sql table I want to calculate all the fields to total sum field.

Answer 1

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.

Sign up