At 12:26 PM 09-02-02 +1100, I wrote:

>I think Firebird could handle this:
>
>declare variable EmptyBlob blob sub_type 1;
>begin
> EmptyBlob := ''; /* assign an empty string - works in Firebird only */

Next line:

>/* if (BlobCompare (new.MyBlobCol, :EmptyBlob) = 0) then */

but BlobCompare() returns 1 for true, 0 for false so the predicate should be

if (BlobCompare (new.MyBlobCol, :EmptyBlob) = 1) then

> begin
> ....
> end
> else
> begin
> /* do something with new.MyBlobCol */
> ...
> end
> ....
>end

regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com