On Mon, 03 Sep 2012 07:00:18 -0000, "sir_wally_lewis" <[email protected]> wrote: > 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?
Use the built-in function ASCII_CHAR: http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-ascii_char.html Mark
