Subject | Re: [firebird-support] trigger before update column name |
---|---|
Author | Yves Cravic |
Post date | 2009-04-06T17:03:21Z |
firebird-support@yahoogroups.com le lundi 6 avril 2009 � 17:03 a écrit:
update Table set column2 =7 where id=2
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]
>something like:If the
>
>if (new.column2 is not distinct from old.column2) then
>new.column6 = current_date;
>column2initial 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]