Board index » delphi » assigning a Memo into a dynamic updateSQL at runtime

2003-10-13 08:22:38 PM
delphi161
I get this error message:
"operation is not supported on blob fields".
OBSERV IS A MEMO TFIELD OF THE EXPDIENT TABLE.
...
Qupdateexp.sql.add(', OBSERV= :OBSERVAC');
Qupdateexp.sql.add(' where Exp.Nexp ='+ ''''+ENexp.text+'''');
QUPDATEexp.PARAMBYNAME('OBSERVac').ASSTRING:= MObserva.TEXT;
Qupdateexp.execsql;
This is the sql string I get:
update ":servijur:EXPDIENT.DB" Exp set NOMEXP ='Name', OBSERV= :OBSERVAC
where Exp.Nexp ='03/0016'
--
Jordi Bardaj?
Gabinet Informàtic de C.S. CC.OO. Illes Balears