At 12.18 11/09/2000 +0200, you wrote:

>
>Hello,
>
>Why that triggers doesn't work ?
>I would like to set the today Date in column ac_Datemodif after an update.
>
>CREATE TRIGGER ACTIONS_UPDATE FOR ACTIONS
>ACTIVE AFTER UPDATE POSITION 0
>as
>BEGIN
>UPDATE CONTACTFICHE
>SET C_DATEMODIF="NOW"
>WHERE old.ac_codecontact=c_code;
>new.ac_DATEMODIF="NOW";
>END
>
>The instruction, work :
>UPDATE CONTACTFICHE
>SET C_DATEMODIF="NOW"
>WHERE old.ac_codecontact=c_code;
>
>But not :
>new.ac_DATEMODIF="NOW";
>

use 'now'.....
With regarsd,
Marco