Information générale
Titre:
ODBC field name using non-standard characters
I have connected successfully, using ODBC, to some remote data. In my case its to Btrieve data, but that's not significant for this question.
Most of the tables have "normal" field names and work fine. The tables I now have to access, have field names like the following:
AM>Driver
AM>Order #
AM>Order Date
My error message says that there is no such column. I saw an earlier thread (but can't currently find it) that talked about problems with the # character and had some sort of workaround. I seem to also be having trouble with the > character. I'm also confused as to how to handle imbedded spaces in the field names. I'm trying to do something like
SELECT * FROM TheTable WHERE (AM>Order #) = "12345"
I don't have the option of having the field names changed in the remote data.
Bob
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