You could alias the table name....
e.g.
UPDATE "current.db" C
SET C."Well"="TATS"
WHERE C."Well"="AT-201"
HTH,
Mike
> -----Original Message-----
> From: Mark Derricutt [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, 7 December 2000 10:08
> 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
