Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with field name
I'm having a problem with an ODBC connection from VFP6 to a dbase III table. One of the fields has a ':' ( example, type:zone ) in it. I can do a select statement with the field referenced like this, [type:zone]. However, I am unable to get an insert statement to function. The Microsoft dbase odbc driver is saying that the field name, [type:zone], is an invalid name.
A shortened example of my insert statement is as follows:
Insert into table ( [type:zone] ) values ( 'fielddata' )
Any other field in the table doesn't have the colon. And the above insert example works just fine in regards to any other field. I've searched the
MS knowledge base without any luck.
Any ideas???
Thanks
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