Subject | Adding blobs in SP |
---|---|
Author | sdbeames |
Post date | 2002-09-14T00:32:47Z |
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
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