Hi Nadya,

My question was about SQL Server tables, anyway what you told me may help me and the future.

Thanks


>Hi Luis,
>
>Funny, I asked today the same question. You can not Update the same table with the triggers, but you can use Table Rule for such update. For instance, I use UpdateModidate() function, which just has replace Modidate with datetime()
>
>See Re: Triggers Thread #701299 Message #701326 for more discussion...
>
>>Hi friends, I have a very a question: How can I create a trigger that updates other fields in the same table? I mean, I know (but I'm not sure ;)) that I must create an update-trigger (a trigger that executes whenever a tables has been updated, sorry for my english) but I never created a trigger so I would like any of you to help me create one. My problem is that I need to record on two fields (cUserModified and cDatetimeModified) the user and datetime that the data on the record was last modified. My VFP app uses a DSN connection with Windows NT autentication (trust connection) so SQL Server knows already who is accessing data.
>>
>>Any help would be useful.
>>
>>TIA
>>
>>Luis