I tried to do a SQL statement with a parameter on a Blob but being a memo field - this stuff works with FIB plus so I thought it should not be a problem WRONG!
sql := UPDATE
SET MEMOFIELDNAME = :MEMOFIELDNAME
WHERE
(Q being a TIBCSQL)
Q.PARAMBYNAME(MEMOFIELDNAME).value := StringList.Text;
Q.autocommit :=true;
Q.execute
crash !! Blob and array types are not supported for move operator
it is just text why you cannot insert or replace it simply like that?
Any work around?? please
regards
PW
Update/Insert of a Memo field
Update BLob
I kinda made it work
by adding
q.parambyname().asIBBLob.isUnicode := true;
q.parambyname().aswidestring := text;
so it does crash any more
it stores something but the unicode characters are wrong
they are not translated
the field is blob sub_type 1 character set UTF8
what do I have to tell the parameter in addition to??
thanks
PW
by adding
q.parambyname().asIBBLob.isUnicode := true;
q.parambyname().aswidestring := text;
so it does crash any more
it stores something but the unicode characters are wrong
they are not translated
the field is blob sub_type 1 character set UTF8
what do I have to tell the parameter in addition to??
thanks
PW