At 11:33 AM 09-02-02 +1100, Geoff Worboys wrote:

>I believe it was a sub_type 1 blob that he was using. It was me that
>suggested the trigger code built for that column was inappropriate for
>a blob (comparing the blob column to a blank string).
>
>Am I wrong? Is firebird now able to automatically translate text
>blobs inside trigger/procedure languages to allow direct text
>assignments and comparisons??

I think Firebird could handle this:

declare variable EmptyBlob blob sub_type 1;
begin
EmptyBlob := ''; /* assign an empty string - works in Firebird only */
if (BlobCompare (new.MyBlobCol, :EmptyBlob) = 0) 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