 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Cenk
Guest
|
 Posted: Fri Aug 04, 2006 8:49 pm Post subject: TADOConnection problem |
 |
|
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? |
|
| Back to top |
|
 |
MarkR
Guest
|
| Posted: Fri Aug 04, 2006 8:59 pm Post subject: Re: TADOConnection problem |
|
|
| Quote: | CountQuery->Open ();
count = CountQuery->FieldByName ("COLUMN1")->AsInteger;
|
Try CountQuery->Close();
| Quote: |
CountQuery->SQL->Clear(); --------> CAN NOT PERFORM THIS OPERATION ON AN
OPEN DATASET! |
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
