Yes with CA and VFP8+. However possible with earlier too. Then where slightly differs:
where oldval(myview.myTimeStamp) == curval(myView.myTimeStamp)
Actually rethinking this where would be easier to construct this way for both the CA and w/o CA (just add both PK and timestamp as keyfields and mark at least timestamp as updatable).
Cetin
>Ah, with CursorAdapters. I think that is VFP8 or later, right? I see that it gives you possibilities that are not otherwise available.
>
>Thanks a lot for your comments.
>
>>No not in trigger just modify your where clause (with CA you've control over updatecmd):
>>
>>where pkkey = pkkey and myTimestamp = curval(myView.myTimeStamp)-1
>>
>>* myTimeStamp is incremented by one in CA cursor
>>Cetin