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