Thanks for the idea, I'll try it and tell you.

TIA.


>Here's sample trigger that updates 'fld_dt' field with the current datetime for any updated records.

CREATE TRIGGER mytrigger
>ON mytable
>FOR UPDATE
>AS
>BEGIN
>  -- Don't update if it's recursive call from the same trigger
>  IF NOT UPDATE(fld_dt)
>	UPDATE mytable
>		SET fld_dt = getdate()
>		FROM mytable
>		INNER JOIN deleted ON mytable.pkfld = deleted.pkfld
>END

>
>>Sergey, the examples don't give me any idea on how to do it, they just explain how to update other tables but in a batch way. I can´t know what record has changed, it only give me examples on knowing columns states, so would it be difficult to do it? I would do it in a VFP store procedure but those don't allow me to update the same table that the trigger belongs to.
>>
>>Thanks, I hope you or somebody else can help me with this.
>>
>>Luis
>>
>>