🚀 go-pugleaf

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