🚀 go-pugleaf

What database engine are you using?  Are you using ODBC or a native OLEDB
driver?


"Peter Schoner" <schoner@wirtschaft.uni-kassel.de> wrote in message
news:3d2c5864_2@dnews...
> Hi Arnie!
>
> Yes, that is the way I tried to work it out. Yet I don't have the problem
to
> get the data with
> qry->FieldByname( "MyCount" )->AsInteger;
>
> The problem is that I simply cannot passthrough the query
> "select count(*) MyCount from ATable where x=25"
>
> as count(*) is an aggregate function. I know that MS Access (or Interbase,
> ORACLE) could work with it. But I get the error message
> "project raised exception classEDBEngineError with message 'Table is read
> only'".
>
> Does anyone has a glue how to solve it. I wonder why this is not possible
> with BCB5!
>
>
> Peter
>
> "Arnie Mauer" <amauer@vrms.com> schrieb im Newsbeitrag
> news:3d2c5267$1_1@dnews...
> > 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
> > >
> > >
> >
> >
>
>