At what stage do you get your "invalid use of keywork update" message?
I can't imagine it's coming from your database...
You could try:
select {field}, update newName from {table} or...
select {field}, update as newName from {table}
which might work.
Otherwise there's the astonishingly gross:
select * from {table}
.. but it might work for you.
BTW: There's a '[EMAIL PROTECTED]' which we're supposed to use, so we
don't irritate the non-db crowd.
Cheers,
Kerry Sainsbury
Brocker Investments
-- Win2k: "It's not so much that it's only 65,000 bugs,
it's just that they stopped at 65,535 to prevent an overflow"
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Wednesday, April 19, 2000 5:38 PM
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
