> When I try to compare Blob in a Trigger, this error occurs:
>
> if( old.Obs != new.Obs ) then...
>
>
> SQL Message : -901
> Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements
>
> Engine Code : 335544382
> Engine Message :
> BLOB not found
>
>
> Im using Firebird 2.1
>
> Is there a way to do that ? or a better way ?

By using the IS DISTINCT FROM clause.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/