🚀 go-pugleaf

sorry i mistyped in my original post i used "," and it says the error,both 
"," and ";" doesnt work with
ado and access 2007. is there a bug with the odbc drivers and access 2007?


"Vassiliev V. V." <support@oledbdirect.com> wrote in message 
news:460f6f6c$1@newsgroups.borland.com...
> Access SQL used in ADO differs from SQL in Access itself. Correct syntax 
> should be ',' instead of ';' as column separator:
>
> select a, b from peers where ab = 'a1'
>
> //------------------------------------------
> 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)
>
>
>
> "billaras" <billaras1234@hotmail.com> �������/�������� � �������� 
> ���������: news:460f0952@newsgroups.borland.com...
>> im trying to run the following simple query through an adoquery in
>> borland c++ builder 2006(the borland developer studio)
>>
>>  ADOConnection1->Connected=true;
>> ADOQuery1->SQL->CommaText="SELECT a;b from peers where ab='a1'";
>> ADOQuery1->Active=true;
>>
>> i get an error message saying operator missing between a and b....
>> if i run it through access it runs normaly.
>>
>> i have connected the adoquery to an adoconnection and with odbc access 
>> drivers to access database
>>
>>
>> any ideas?
>> thks
>>
>
>