-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
With Local SQL you can get around this by using the format
tablename.fieldname instead of just fieldname.
Since I don't know what you're using I couldn't say whether this will work.
The following is an extract from Local SQL Help
Columns
Local SQL supports Paradox multi-word column names and column names that
duplicate SQL keywords as long as those column names are
Enclosed in single or double quotation marks
Prefaced with an SQL table name or table correlation name
For example, the following column name is two words:
SELECT E."Emp Id" FROM EMPLOYEE E
In the next example, the column name duplicates the SQL DATE keyword:
SELECT DATELOG."DATE" FROM DATELOG
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, 19 April 2000 17:38
> To: Multiple recipients of list delphi
> Subject: [DUG]: TQuery and a field called Update
>
>
>
> A app I am working on has a field called Update which I can't change
> because the database is shared with other apps. How can i make the query
> 'select {field}, update from {table}' work? It returns invalid use of
> keywork update. I tried 'select {field}, "update" from {table}' but that
> just populates the field update with update on every row.
>
> Any Ideas?
>
> James
>
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.0.2i
iQA/AwUBOPyv1ATDOUeLQzcDEQKyLQCfU6uwzxd0bpo20d5yK2DGKnjB9doAn3CW
dEW2mYniTZXPPUVKElk2d8d+
=6v/2
-----END PGP SIGNATURE-----
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
