🚀 go-pugleaf

Try

SELECT * FROM [TableName] WHERE [TableName].[FieldName] = "Value"

or just

SELECT * FROM [TableName] WHERE [FieldName] = "Value"

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Bulent COSKUN" <bulent.coskun@e-kolay.net> �������/�������� � ��������
���������: news:3ecf4d1a@newsgroups.borland.com...
> Hello,
>
> I write smiple code with using ADO Components in BCB6.
> I was designed my DB with ACCESS 2002.
> When I use Jet4.0 OleDB provider on ADOConnection Component,
> I getting "Unspecified Error".
>
> The Case:
> Set ADOConnection Conponent's ConnectionString with Jet4.0 OleDB Provider
> and Select .MDB file
> Than,
> Uset ADOQuery with SELECT * FROM TableName WHERE TableName.FiledName =
> "Value"  Statement
> Than,
> Execute to Query.
> "Unspecifed Error" appear.
>
> In Fact, When use "SELECT * FROM TableName" Statement in ADOQuery Object,
> Everything normal, and when I use ODBC provider everthing normal too.
>
> I didn't understand this case.
>
> Do you have any advice?
>
> Bulent C.
>
>
>
>
>
>
>