>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?