>Keep in mind, however, that will only take care of inserted records. To update existing records, simply place the GetDate() function in your update command for your datetime field.
>
>i.e.: SQLExec(lnHandle, "Update TableName Set DateTimeField=GetDate() Where Condition")
>
>That should take care of the updates for you.
>
Yes, you're right. But is there a way to set a trigger to update only the update records?

The 'CREATE TRIGGER FOR UPDATE' updates all the records with the new datetime.

Can you help?

Thank you.