🚀 go-pugleaf

Hi Peter,

If I understand you correctly, something like:
qry->SQL->Add( "select count(*) MyCount from ATable where x=25" );
qry->Open();
int myCount = qry->FieldByname( "MyCount" )->AsInteger;

- Arnie

"Peter Schoner" <schoner@wirtschaft.uni-kassel.de> wrote in message
news:3d2c4602_1@dnews...
> Hi!
>
> I am very familiar with SQL but not with the complete BCB5 possibilities.
>
> I simply wanted to get a number of records with
> Form1->SQL_Params->SQL->Add("select count(*) from T_output where i_Reakt =
> 'R01'");
>
> or the values
> Form1->SQL_Params->SQL->Add("select diestinct i_Reakt from T_output");
>
>
> However the help file says:
> "A live result set for a query against a single table or view is returned
if
> the query does not contain any of the following:
>
> DISTINCT in the SELECT clause
>  Joins (inner, outer, or UNION)
>  Aggregate functions with or without GROUP BY or HAVING clauses
>  Base tables or views that are not updatable
>  Subqueries
>  ORDER BY clauses not based on an index"
>
>
> So, how can I ask these questions to my database? It does not work with
> TQuery! Does it work TIBQuery?
>
>
> Thanks in advance
> Peter
>
> .........................
> Dipl.-Math. Peter Schoner
> MAIL: schoner@wirtschaft.uni-kassel.de
>
> Uni Kassel -- Wirtschaftswissenschaften
> FG Produktionswirtschaft und Logistik
> www.wirtschaft.uni-kassel.de/vahrenkamp
>
> Nora-Platiel-Str. 4 -- 34127 Kassel
>
>