Subject Re: [firebird-support] trigger before update column name
Author Yves Cravic
firebird-support@yahoogroups.com le lundi 6 avril 2009 � 17:03 a écrit:
>something like:
>
>if (new.column2 is not distinct from old.column2) then
>new.column6 = current_date;

If the
>column2
initial value is 7 and then I send the SQL :
update Table set column2 =7 where id=2

>new.column2 is not distinct from old.column2)
is true an then
>new.column6 = current_date;
What I would like is: nothing must happend when an update is sent to
column 2.



Yves Cravic
Antenna
tél 02 51 66 84 37
fax 02 51 66 89 09
E MAIL ycravic@...



[Non-text portions of this message have been removed]