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 VFP 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?
Thanks
Jim