> Sorry, John, I missed the possibility that your problem was coming
> from having sub_type 0 blobs. Exactly the same problem hit me during
> testing and I had to rebuild my test database, re-storing sub_type 0
> blobs with sub_type 1. I *thought* I had documented it, too, so I'll
> go back and check up on that.

Helen,

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??

--
Geoff Worboys - TeamIBO
Telesis Computing