Well here is a **guess**...

The SET REFRESH might be resetting the interval to start 'fresh'.

Maybe if it was not inside the "Edit" button (set it in the Load() or Init()) it might have a different effect.

good luck


>Thanks Jim and Woodie,
>
>I tried this in my "edit" button's click() :
> SET REFRESH TO 2,2
> = TABLEUPDATE(0) && new to force refresh
> GO RECNO() IN (ThisForm.OldAlias) && new to force refresh
> sys(1104) && exist only in VFP8???
>
>
>
>It's strange, it works on most situation EXCEPT with one case (maybe more but one I know of). In that situation, the refresh does not occurs the first time. I do "edit" and the refresh does not occurs, I undo (basicly tablerevert) then the changes appears. Try it again making changes from somewhere else, then it start working, meaning the "refresh" works as soon as I click "edit". Get out of the form, start testing again, same thing, the first time it won't work. Checked out with other tables in the same form, works fine the first time. The only difference I can see right now is the table with problem is much bigger then the other ones I'm testing with.
>
>I did a set step on to check it out, I'm always in the good table.
>
>Any ideas anyones?
>Diane
>
>
>
>>Have a close look at the SET REFRESH command. Even though the preamble says clearly that it is effective only for BROWSE windows, that is NOT the case.
>>
>>Note that VFP9 give much more flexibility as regards this problem.
>>
>>Using SET REFRESH in your VFP6, keep in mind that it only takes integer values for its arguments.
>>Also you need to know that the time intervals you set in the command do not guarantee that buffers will be updated every 'n-specified' seconds. Rather, this time is examined when an I/O is initiated and if the interval has lapsed then the refreshing is performed.
>>I believe that you can safely force this to happen by issuing a simple

GO RECNO() IN < alias >

>>
>>good luck
>>
>>
>>>Hi everyones,
>>>
>>>In a multi user environment, all my forms use private datasession and all my tables are open with buffered mode 5 (optimistic table locking).
>>>
>>>Now when two users look at the same table and one user change the value on one record how can I "force" the display on the second user screen to be "refresh" with the new data? It can be a manual command (like whenever a user click the "update" button, the program will force a refresh first). I know for a view but the programs use vfp tables directly.
>>>
>>>BTW sometimes it seems the refresh is done automatically and sometime not. I don't understand the behavior. Any theoritical explanation is welcome.
>>>
>>>TIA