Subject RE: [ib-support] Adding blobs in SP
Author Alan McDonald
what's String2Blob ? it's not part of FreeUDFLIB
-----Original Message-----
From: sdbeames [mailto:s.beames@...]
Sent: Saturday, 14 September 2002 10:33
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~)
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


Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

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

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