Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
HI,
I searched in MSDN.microsoft.com and I found something :
Article ID: Q138501
PRB: Modifying a Remote View Results in a Syntax Error
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Visual FoxPro for Windows, version 3.0
Microsoft Data Access Components version 2.5
-------------------------------------------------------------------------------
SYMPTOMS
After you create a remote view to gain access to a remote data source through ODBC, any attempt to modify the remote view results in a Syntax Error.
CAUSE
One or more of the field names in the tables included in the remote view contains a space or other special character, such as one of the following:
~ !
RESOLUTION
Do not add tables that have spaces in field names to a remote view. Use the underscore (_) character in place of a space. Alternatively, use the CREATE SQL VIEW command to modify the remote view. Follow the same naming conventions used for table and field names.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
I simply created a local view on the remote view and it solved my problem . I am still wondering if there is not a simpler way to accomplish the task.
Thank you,
Christian Cote
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