More on the Zone
If I put quotes around the word "ZONE" then it works, but the fieldname in
the resulting dataset is "Expr1001"
Bit of a bummer, I think I am better off to change Zone to ZoneName..
Thanks for your help
Chris
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dennis Chuah
Sent: Thursday, 13 January 2000 13:30
To: Multiple recipients of list delphi
Subject: RE: [DUG]: More Strange ADO Stuff - Now it does not like a
field called "ZONE"
Chris,
> Thanks Dennis...
>
> It fixed it but WHY?
>
> Chris
Zone is most probably a reserved word. To use reserved words as
identifiers, you need to quote them with "". I think Access will also allow
you to use []. Not quote sure what Zone does, as I don't use ADO/Access.
Regards,
Dennis.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz