Using the inverted quotation marks really did not work well I was having problems debugging it so I used the folling lines that works well. Just thought you would like to know.
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) + "',";
+ 'rf_text =?References_main.rf_text,';
+ 'rf_inter =?References_main.rf_inter,';
+ 'rf_cmnt =?References_main.rf_cmnt';
+ " WHERE rf_num = " + ALLTRIM(STR(references_main.rf_num))
lnTest = SQLPREPARE(THIS.ln130Checklist,lcSql)
Darren Mc Dowell
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