>>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.
What does your trigger look like (code example)? It doesn't sound like you have a where clause on your Update statement.
The updated records can be accessed using the special internal table Inserted within the trigger. You can declare a cursor and loop through it to update invidual records or you could use that in a subsuqery.
update mytable set DateTimeField=GetDate() where KeyField In (select KeyField from Inserted)
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao