Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Your best bet is to create a remote view of the table that does not have the # character in the name and do your updates through this view. If you are using SQL Server this remote view would be a SQL Server view.
I usually create views of all my SQL Server tables and then connect to the view through VFP remote views rather than the table.
>I am connecting remotely to a table that has the field "Next_Trans#"
>
>Whenever I try to update the field, VFP comes back with Field Not Found Next_Trans
>
>It seems that VFP is having a problem with the # in the field name. Has anyone ever dealt with this kind of behavior?
>
>Thank you,
>Chris Holtz
Précédent
Suivant
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