General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Jim
The Help file will show you how to "Create SQL View" in code.
The DBGETPROP() will show you the SQL that is generated by the wizard which can be used as a starting point.
The Wizard is only a tool, it is not a requirement.
Also look here in downloads for a tool called eview, it will help you up the learning curve.
regards
>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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only