what's String2Blob ? it's not part of FreeUDFLIB
Alan
-----Original Message-----
From: sdbeames [mailto:s.beames@...]
Sent: Saturday, 14 September 2002 10:33
To: ib-support@yahoogroups.com
Subject: [ib-support] Adding blobs in SP


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


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]