Information générale
Titre:
SELECT * FROM and the apostrophe
Hello!
I got a problem using apostrophe in the fields, upon I need to search a data I got error because the data has apostrophe, here is a example:
cVar="Bob's Sample"
cSearch="SELECT * FROM CUSTOMER WHERE BusinessName= '"&cVar&"'"
MyData.Open cSearch, objCmd, adOpenKeyset, adLockOptimistic, adCmdText
At this time I got error because the apostrophe, and if I try to not use apostrophe after BusinessName I got other error because it is a character and need the apostrophe.
Any advice or suggestion.
Thanks,
Gerardo
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