Current is the current date and time.
Can you quote the tablename as well as the field.
eg. "current"."well"
Another idea. If you are using multiple databases you can do something like:
...
where DATABASENAME.TABLENAME.FIELDNAME = "BOB"
It is possible that this could be used to solve your problem.
I havn't tried these. Just suggestions.
Stacey
> -----Original Message-----
> From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 7 December 2000 10:08 a.m.
> To: Multiple recipients of list database
> Subject: [DUG-DB]: table name is reserved word...
>
>
> Hi, just come accross a problem with the database here
> (paradox based),
> the following query is failing due to 'current' being a
> reserved word (not
> sure what its used for thou), does anyone know how I could get around
> this?
>
> UPDATE current SET current."Well"="TATS" WHERE
> current."Well"="AT-201"
>
> --
> "We don't guarantee anything except that it will take up disk
> space..."
> Apache 2.0alpha5 Disclaimer
>
> Now Playing: <no audio cd present>
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
