Re: Trigger to update last date & time changed...

[Jean-Michel OLTRA]

        bonjour,


Le lundi 17 mai 2004, Zabach, Elke a �crit...


>       INSERT INTO JM.HISTORIQUEGARANTIEINTRANT VALUES
>         (
>             :OLD.IDGARANTIE,
>             :OLD.IDINTRANT,
>             :OLD.IDETABLISSEMENT,
>             DATE,                                <----
>             :OLD.DEBUTGARANTIE,
>             :OLD.FINGARANTIE
>         );

> why is this not done easier?

I did not knew the trick.
So do I now.

Thanks.

-- 
jm


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]