> 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
