Darren,
Try to invert quotation marks and double quotation marks.
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
>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
Roberto Cysne Costa