Error renaming field in SQL command - 07-06-2003 , 10:28 AM
I am trying to select specific records in a Pervasive 2000 table using a SQL
The command is :
SELECT name AS customer, desc AS description FROM tblroll
However, it gives a syntax error. It seems that "desc" is a reserved word.
Unfortunately I do not have the luxury of changing the field name as I am
simply connecting to a database from another application to manipulate the
results for my own application.
Does anyone have any ideas on how I may choose this specific field from the
Thanks in advance.
Re: Error renaming field in SQL command - 07-06-2003 , 09:32 PM
You'll need to enclose the field name in double quotes:
SELECT name AS customer, "desc" AS description FROM tblroll
That will allow you to access the field.