> I got a simple question on use of queries.
> When I have a query like talhis
>
> 'Select SUM("Value") from TABLE';
>
> That's gonna show me the total (sum) of field Value from table TABLE.
>
> But how can I show the result of this query on a label or edit box on
> Delphi?
>
> I tried to create some procedures and functions, but no way.
>

Since there is only one field, you can use the Fields[0] property of the
query component to get the value.

HTH

Woody (TMW)
__._,_.__Or give the field a name. SELECT SUM("Value") AS TOT_VALUE FROM TABLE

Roger Vellacott


[Non-text portions of this message have been removed]