Subject RE: [IBO] Simple doubt on query
Author Roger Vellacott
> 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.


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]