| Subject | Writing Carraige returns into a field using SQL |
|---|---|
| Author | sir_wally_lewis |
| Post date | 2012-09-03T07:00:18Z |
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.
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.