Subject Re: [ib-support] trigger on a blob field
Author Artur Anjos

I'm afraid you will need an UDF to check this. When you do (old.notes <>
new.notes) you are just comparing the Blob ID, not the data inside the Blob.
(Blob data is stored elsewhere, and the row just keeps an ID to it).


----- Original Message -----
From: "Roger Pullen" <rpullen@...>
To: <>
Sent: Wednesday, December 04, 2002 9:41 AM
Subject: [ib-support] trigger on a blob field

> Hi all
> Need to log if users have altered text in a blob field
> on a before update trigger something like...
> if (old.notes <> new.notes) then
> begin
> insert into
> log_notes
> (refnum,old_notes,new_notes)
> values
> (main_property.refnum,old.notes,new.notes);
> end
> works fine if there is "old" text already there
> but not if there is no text to start with
> Is this a limitation of memo (blob) fields??
> Regards
> Roger P