newsreader Guest
|
Posted: Sat Aug 28, 2004 6:21 am Post subject: How to get the return velue of a TQuery SQL statement |
|
|
Hi,
Let's say I have a database with one of the column that contains the
following values:
ItemCount = {10, 20, 10, 25, 35, 20, 10}
And I executed an SQL query like: "SELECT Sum(ItemCount) FROM MyTable",
which should return the value 130. However, I couldn't figure out how to
retrieve this value after the TQuery1->Open(). Anyone have any idea how I
could retrieve this value? Thanks in advance.
Regards.
|
|