How can I put the result of a SQL sentence in a variable???

[colosoderada]

Hi everybody, my problem is that I have a sentence in SQL

Select Count(*) from TABLA where Name = Peter

and I need know the result of this sentence, I would like the result in a variable.

How can i do it???

Any idea????

Thank you in advance.

Sorry for my english. (I´m spanish).

 

[hnd]

Use the method SQL_Exec in the class TQuery.


hnd
hasso55@yahoo.com