Which variable holds the Count result? 1

[Wavelet]

For example, when a SQL statement like this: Query1->SQL->Add("select count(*) from table where free=false&quot is executed and the result should be 5, my question is where can I find the variable that holds the result "5" ?

 

[qwe0502]

Hi there,

if your field has the Name of xy you can access it like
try
{
Query1->Open();
Query1->Fields->FieldByName( "COUNT OF xy" )->AsInteger;
Query1->Close();
}

Hope this will help

Benno

 

[Leonix]

You can try also this:

Query1->SQL->Add("select count(*) AS Result from table where free=false");
Query1->Open();
int res = Query1Result->AsInteger;
Query1->Close();

The variable res will hold the value.

Bye.
Leonardo.

Leonardo Mattioli
Chief Program Manager
Z Forge snc -

http://www.zforge.it