Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi Ken
>when going from local to remote views, at least with a foxpro database on the back end there are some field names that will cause the ODBC driver to throw a confusing syntax error.
>
>i've not seen them documented and I think they should be but so far I have come to realise
>
>VALUE and DESC can not be field names if you hope to go to remote views/odbc.
>
>i had value in a key table and desc as a short for description in a stock table, it's annoying to have to change base tables, views and all related code at a late stage.
>
>anyone know of any others, or even if this is documented somewhere?
>
>Ken.
The simple answer is not to use any keyword as a field name or memory variable name.
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