In other words: How can I get the username that is using my app so I can store it in the field?
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
>>
>>