🚀 go-pugleaf

Add

CountQuery->Close();

when you do not need this dataset open. Btw if in first dataset you want to 
get count of records in second dataset, you will have wrong result - select 
count(bid) returns count of rows where bid is not null.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Cenk" <cenk1536@yahoo.com> �������/�������� � �������� ���������: 
news:44d36e64@newsgroups.borland.com...
> Hi,
>
> I wanna use multiple select statements as below but it gives error, would
> you please help?
>
> sample code segment.
>
> TADOQuery *CountQuery;
> CountQuery= new TADOQuery (this);
> CountQuery->Connection = ADOConnection1;
>
> CountQuery->SQL->Add ("select COUNT(bid) from ["+table+"]");
> CountQuery->Open ();
> count = CountQuery->FieldByName ("COLUMN1")->AsInteger;
>
>
> CountQuery->SQL->Clear(); --------> CAN NOT PERFORM THIS OPERATION ON AN
> OPEN DATASET!
> CountQuery->SQL->Add ("select [bid],[fTime] from ["+table+"] order by
> [fTime] ASC");
>  CountQuery->Open ();
>
> How can i use multiple TADOQuery?
>
>