Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
What's the database?
It should work on an Access db.
>Help!
>
>The following command is failing:
>
>cnPdox.Execute "INSERT INTO Method2 ([Contract #]) VALUES ('10092169');"
>
>with the message:
>
>The INSERT INTO statement contains the following unknown field name:
>'Contract #'. Make sure you have typed the name correctly and try the operation again.
>
>[Contract #] IS a valid field, a KEY field in fact. SQL sees it in an UPDATE query WHERE statement, but not in the INSERT query. Is there a problem with the # character? If I use the same INSERT command with a different field name, it works properly. What is it about the field name 'Contract #'?
>
>Thank you in advance for your time!
>John
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