alter the if statement to be:
if (old.notes <> new.notes) or (old.notes is null) or (new.notes is null)
then
try that....

-----Original Message-----
From: Roger Pullen [mailto:rpullen@...]
Sent: 04 December 2002 09:41
To: ib-support@yahoogroups.com
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



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/