I looked into this problem a bit more, putting quotes around the name just
makes it an expression.
But you were right about the [] in access. That did the trick
Chris
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Chris Crowe
Sent: Thursday, 13 January 2000 18:03
To: Multiple recipients of list delphi
Subject: RE: [DUG]: More Strange ADO Stuff - Now it does not like a
field called "ZONE"
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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
