Create a view of the table with a different column name? Cheers, Carl -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 19 April 2000 3:38 PM 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
