Thanks Dennis...
It fixed it but WHY?
Chris
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dennis Chuah
Sent: Thursday, 13 January 2000 10:25
To: Multiple recipients of list delphi
Subject: RE: [DUG]: More Strange ADO Stuff - Now it does not like a
field called "ZONE"
> If I run a select query with the field name of "ZONE" I get
> an EOLEException
> message saying either "Unspecified Error"
>
> Is "ZONE" a reserved word in ADO, or the OLD DB provider for Jet 4.0?
>
> I am connecting to an Access97 Database (*.MDB) using the
> OLE DB Provider
> for Jet 4.0
>
> This is the code.
>
> GetZoneQuery.Sql.Add('SELECT Zone');
Try GetZoneQuery.Sql.Add('SELECT "Zone"'); (Note the double quotes).
Regards,
Dennis.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
