Matze wrote:

> OK thank you.
>
> I changed my trigger in the following way:
>
> AS
> begin
> if ((new.rbcard <> old.rbcard)
> or (new.anrede <> old.anrede)
> or (new.v_name <> old.v_name)
> or (new.n_name <> old.n_name)
> or (new.telefon <> old.telefon)
> or (new.handy <> old.handy)
> or (new.email <> old.email)
> or (new.comment <> old.comment)
> or (new.bonus <> old.bonus)) then
> new.last_changed = current_timestamp;
> end
>
> but the trigger workes only on some datasets. Sometimes the trigger does not change the last_changed field
>
> Whats wrong now ?
>

Maybe the changed fields changed from/to null, add logic to handle null.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br