Information générale
Catégorie:
Codage, syntaxe et commandes
I have a lot of Character fields that I am uddating onto Sql Server.
I have written a .prg to do this, using a SqlExec as in
nResult = SQLEXEC(lnHandle,lcInsert)
and the Insert includes all the fields just strung together
(Insert into MyTable (Fld1,fld2,fld3) Values 'aaaaa','bbbbbb','ccccc')
Working for the most part .
I have a lot of Single quotes in the Columns so I do a Replace MyField with Strtran(Myfield,"'", "''")
(Replace a Single Quote with a double quote, otherwise SQL command goes mad)
This workks for the most part, unless for instance there are lots of Single Quotes (or a single quote as the very last charcater in the field), in which case the data gets truncated, sometimes ending up with a single quote any way and an error
Is there a more elegant/better way to do this (if I was using .Net , I'd use Paramaters but dont htink I can do this in .prg)
so as to overcome this single quote problem
Tia
Gerard
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