>>>Hi Cetin,
>>>>>>
>>>>>>I have a table in optimistic Table buffered mode. When my form is in EditMode, I can edit records, then I want to save my changes. I issue TableUpdate. My question is: how can I determine, which records were actually updated? I want to replace modidate field with datetime() for these particular records.
>>>>>>
>< snipped >
>
>I'm alittle confused here. If the records are already Tableupdated(), will Getnextmodified() return any modified records? After all, no new modifications have been performed after the table has been updated.
>
>Nadya,
>Why can't the replace the Modidate field as you enter EditMode? Do you need the exact update time? Just a thought.

Hi Larry,

I thought about it too, but it's not clear for me, how can I do it this way.

I have our navigation bar and a pageframe with Edit/Browse (one record/Grid).

When I click on Edit button, I switch into Edit mode and can modify my records.
If I want to save my changes (made in several records) I click on save button (or on close - in this case the question comes up "Do you want to save?") and save my changes issuing Tableupdate. I can also revert my changes, clicking on Revert button.

So, as you can see, I want to replace modidate with datetime() for editted records. Of course, it would be non-accurate in this scenario, because I can open my table, make few changes, go to lanch, then return, do some other changes and then save. If I can do it directly while editting the record, it would be better. That's why I thought about triggers also. I'll also put default value into modidate, but it will care only of new records, not for updated...

So, what can you suggest?

Thanks in advance.