Select SUM(YourColumnHere) AS NiceNameHere from Table where id=:id



Artur

----- Original Message -----
From: "Daniel Bertin" <bertin@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, April 29, 2002 4:32 PM
Subject: [IBO] SUM IBOQuery


> Hi all
>
> Would someone please tell me what is the proper and correct way to get
the
> sum of a column, from a IBOQuery into a Delphi variable.
> My SQL is pretty simple,
> Select * from table
> where id = :id
>
> it would be appreciated,
> thanks
> Daniel
>