Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement