Hi, I have a problem, where I need to use SQL to update a Memo field. The textual data includes carriage returns.
This should be simple however the below fails: UPDATE ST_SCLE_PRNT_FMT SET NA_SCLE_PRNT_FRMT = '[2|02:*]' || #13#10 || 'BARFMTDEFAULT=00' || #13#10 || 'USEDATE=SELLDATE' || #13#10 || 'CSYMBOL00=0' || #13#10 || 'CSYMBOL01=1' || #13#10 || 'CSYMBOL02=2' || #13#10 || 'CSYMBOL06=4' || #13#10 || 'CSYMBOLDEFAULT=1' || #13#10 || 'C01=B0,C6,D|27' || #13#10 || 'C02=B0,E6,F|27' || #13#10 || 'I01=B1,C2,D|55' || #13#10 || 'I02=B1,E2,F|55' || #13#10 || 'I03=B1,G2,H|55' || #13#10 || 'I04=B2,C2,D|55' WHERE( ID_SCLE_PRNT_FRMT = 50 ) with error Dynamic SQL Error SQL error code = -104 Token unknown - line 2, column 39 # how can I solve this? Kind Regards, Robert.