>>>If you are working directly with the table, not with a view, CurVal() return the current value in the table. No need to do a refresh in that case.
>>>
>>>HTH
>>>
>>>>The following excerpt is take from the help for CURVAL. If you are using native tables what is the equivalent to Refresh()? Is there one?
>>>>
>>>>"Note If you are working with a view in a multi-user environment, the values returned by CURVAL( ) might not be up to date unless you call the REFRESH( ) function first. Data returned by a view is buffered, and the CURVAL( ) function reads values from the buffer. However, if other users have changed data in the underlying tables for the view, the buffered data is not updated until the REFRESH( ) function is called."
>>>>
>>>>RLOCK
>>>>UNLOCK does not work.
>>>>
>>>>Goto Recno() does not work.
>>>>
>>>>I have ask this question before but can't seem to get a answer. Help!
>>
>>
>>If I do not refresh the buffer I will not get the correct data from the server. Thanks.
>
>As Sylvain said, Kent, when working with the table directly CURVAL() is always up to date. You only need the Refresh for views because the view is a separate entity from the table and therefore does not know when the table has been updated. By working with the table directly this problem does not exist and therefore thr Refresh is not required. Hope I am being cler. HTH

In the following enviroment curval over a network will not return the correct value.

Use native tables.
Buffer Mode optimistic.
Private data session.
Set Refresh to 300,300

By turning down the refresh to 10,1 you narrow the window of a error to one second. With local views and Refresh() you can get the correct data,
but with native tables and no function for refreshing the tables
you do not get the correct value.
Thanks.