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