>Using SQL Server, I am preparing the update line in a string and then using that string to update some fields for the record. I am using the single quote to encapsulate the value. However, sometimes, I can have a single quote in the value. So, I decided to do something like this: ... SET FIELD1='First part'+CHR(39)+'second part'...
>
>However, SQL Server does not understand CHR().
Whenever a single quote occurs in the string , stuff it with another single quote.
******* here is the code
xxx = " This is my sample ' quote "
xxx = strtran(xxx,"'","''")
dynqry = "Update mytable set field1 = " + xxx
?sqlexec(Gnconnhandle,dynqry,'MyCursor')
return
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