Hi

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).

Artur

----- Original Message -----
From: "Roger Pullen" <rpullen@...>
To: <ib-support@yahoogroups.com>
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
>
>