James,
It kinda depends on the DB backend you are using. I would suggest you try
the following:
1. SQL Server
select "update" from ...
2. MS Access
select [update] from ...
3. Local SQL (Yucks)
select tablename."update" from tablename ...
You may have to alias the field to another name in the query, as in:
select "update" newfieldname from ...
select [update] newfieldname from ...
select tablename."update" newfieldname from tablename ...
Moral of the story ... don't use reserved names if you can help it.
Hope this helps,
Dennis.
> -----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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
