What you could do is in the View designer, Under the Fields tab, select your field and go to Functions and Expressions at the bottom of the designer. In that Expression box your Field should have already been place in the expression. Just space over and type

As Descrip

After pressing ok, Added the expression to your Selected fields and that should work around your issue.


>The remote view is created with the wizard. I can't access the SQL statement that it generates.

>The workaround is to use the AS clause
>select mytable.desc as mydesc, mytable.otherfield
>
>DESC is a reserved word.
>
>regards
>>All,
>>
>> I have an application that will be accessing a remote database. One of the fields has the name "desc". When I create a remote view in Visual FoxPro 7 and browse the data I recieve the following error message: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'desc'. What work arounds are there for this bug?