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.
HTH
>Hi!
>
>Specify the GetDate() funtion as a default value of the field. In the Enterprise manager you can do this by using the "Default Value" field at the bottom pane of the table designer.
>
>HTH.
>
>>Hello, All
>>
>>I've runned into one problem:
>>
>>I've defined a table with a DateTime column in MSDE. I want every update of a record in that table to update automatically the DateTime field, using the server's current date and time.
>>
>>I wonder if there is a way to specify this (maybe default value, or something like this).
>>
>>Can anyone help me?
>>
>>Thank you
Travis Vandersypen