Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Native Table Buffering
Message
From
20/11/1998 15:44:56
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
 
 
To
20/11/1998 15:06:20
Kent Vignale
Wolfbyte Software Inc.
Mississauga, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00159852
Message ID:
00159951
Views:
31
>>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
***************************
Bruce Gilmour

"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform