Information générale
Titre:
SQL Pass-Through On SQL Server, Update On Memo Field
I am doing a update sqlexec command in my system and i am haveing trouble with my update command because some of my memo fields have ' marks in it, which makes my sql server error out before it gets to the end of my sql command. Does sql passthrough on sql server require the ' marks around all char field or is their another way I can insert this directly into a sql server text field.
Example:
SELECT References_main
SCAN
lcSql = "UPDATE Referenc Set rf_ordr = '";
+ ALLTRIM(References_main.rf_ordr) + "',";
+ "rf_para = '" + ALLTRIM(References_main.rf_ordr) + "',";
+ "rf_Title = '" + ALLTRIM(References_main.rf_Title) + "',";
* Below is a memo field
+ 'rf_text = "' + REFERENCES_MAIN.rf_text + '"';
+ " WHERE rf_num = " + ALLTRIM(STR(references_main.rf_num))
lnTest = SQLPREPARE(THIS.ln130Checklist,lcSql)
ENDSCAN
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