Nadya,
Given these cicumstances I would probably create a record-level rule. You could call a stored procedure (or a program), pass the alias that is being updated, replace modidate with datetime() in alias and return .T. to make sure the rule validates. See the help topic Using Visual FoxPro - Programmer's Guide - Working with Data - Creating Databases.
Rules are called for every modification to and insert into that table and they are administered by the database engine so you know it will always be fired for every user.
HTH.
>>>>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao