>>>>Hello,
>>>>
>>>>We are using Visual FoxPro 5.0 and we are making a framework. We are using optimistic table buffering. For our security form we are using textboxes and grids. Both are bound to tables. The framework has to be multi-user. If we want to save some new values in the table we are using the TABLEUPDATE(.T.)-command. If the changes are made to the table we want that other users can see the changes on their screens. The problem is that we don't know how to do that. Is there a way to do that? We do use the REFRESH-command. Thank you for your time.
>>>>
>>>>Greetings,
>>>>
>>>>Afier Appelman
>>>
>>>What you ask can be very tricky. You can add a timer to the form to do a refresh every few seconds. But this causes a problem for other users if they are trying to input new values. You do not want to interrupt them by doing a refresh (and potentially losing their input) while they are entering data. You could have an Add/Edit button on the form that stops the timer until they save the data. Then restart the timer (see the interval property of the timer). As long as the user is not inputting data, the timer could be used to refresh the form.
>>
>>Thank you very much for your answer. I think I'm going to try it.
>>
>>Greetings,
>>
>>Afier Appelman
>
>Afier, a simple way to implement the timer is to have it disables when you change ANY data on the form, re-enabled when the data is Saved or Canceled. A simple call in the GetFocus() event of each control (in your base class) would do it.
>

Thank you for your answer, but I think that I will only use a tablecheck because the situation that two or more users will change the same record will rarely happen.

Greetings,

Afier Appelman