CString stmp1;
CString stmp2;
CString txt;
CString selsql;
txt = "{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset204 MS Sans Serif;}}\\r\\n\\viewkind4\\uc1\\pard\\lang1049\\f0\\fs17 \\r\\n\\par }\\r\\n";
stmp1 = "update items set ";
stmp1 += "txt = '" + txt + "' ";
stmp2.Format(" where item = %d and event = %d ",7,8);
selsql = stmp1 + stmp2;
получается
update items set txt = '{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset204 MS Sans Serif;}}\r\n\viewkind4\uc1\pard\lang1049\f0\fs17 \r\n\par }\r\n' where item = 7 and event = 8
что где пропало ?
и всё таки тебе надо \r\n