G'day all,

how can I test the length of a blob parameter passed into a stored
proc? The following gives an "internal error" msg....

PROCEDURE INSERT_SUPPLIER (NewName VARCHAR(90), ~snip~ Note BLOB,
~snip~
if (not (Note = '')) then update SUPPLIERS set NOTE=:Note
where SUPLRNO=:id;

~snip~

(The SP has to check for an existing supplier of the same name, and
insert or modify accordingly.)

Thank you,
Steve
FB WI-V1.0.0.794