Re: ADO Query problem
- From: "Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx>
- Date: Wed, 25 May 2005 23:55:10 +0400
select Coach.[Position] from Coach
Position is keyword in Jet, at least in OLEDB/ADO.
//------------------------------------------
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)
"Ivelin Salabashev" <ivsal@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4294b7ef@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi, all!
>
> I'm using Delphi 7.1 and ADOConnection to Access database (.mdb)
> (Provider=Microsoft.Jet.OLEDB.4.0)
> Connection is OK.
>
> I Create a table "Coach" (in Ms Access ) with one column name as
> Position(text datatype)
>
> Then I create an instance of TADOQuery with the following SQL:
> SELECT
> Coach.Position
> FROM
> Coach
>
> When I try to open this Query I get an EOLEException with message
> 'Unspecified eroor'.
>
> In Access 2003 there is no problem to execute this query.
> There is no problem with ODBC too.
>
> What is the problem?
>
> Thank you!
> Ivo
>
>
.
- References:
- ADO Query problem
- From: Ivelin Salabashev
- ADO Query problem
- Prev by Date: Re: TAdoConnection fails to connect if user not connected as administrator
- Next by Date: Don't want to delete from secondary table
- Previous by thread: ADO Query problem
- Next by thread: Re: ADO Query problem
- Index(es):
Relevant Pages
|
