Subject Adding blobs in SP
Author sdbeames
How can I add two blobs in an SP?
This is where I'm up to...

alter PROCEDURE INSERT_SUPPLIER (~snip~, Note BLOB, ~snip~)
AS
~snip~
if (f_BlobSize(Note) > 0) then
update SUPPLIERS set NOTE = String2Blob(f_BlobAsPChar(NOTE) ||
f_BlobAsPChar(:Note)) where SUPLRNO=:id;

END !!

This just clears the blob field!
Do I have to convert the CSTRING returned by f_BlobAsPChar() to a
VARCHAR somehow first?

Using FB1/XP/FreeUDFLib

Thanks,
Steve