🚀 go-pugleaf

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
>