Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Curval only works after Refresh - despite error
Message
From
20/12/2004 07:46:18
 
 
To
20/12/2004 06:58:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
00970554
Message ID:
00970563
Views:
21
Hi Dominic,

Curval() only work if you are using buffering. Refresh() is used to refresh a view that will generally be either Row or Table buffered. The two functions you refer to usually operate on buffered data and you specify that your table is not buffered. To test for conflicts, maybe you should consider buffering your table.

>Using native VFP tables, I have been attempting to check if another network user has changed a record whilst the present user has been editing (no buffering involved).
>
>CURVAL() does not return the value from disk, but uses a cached value. SET REFRESH seems to make no difference to anything.
>
>If I issue REFRESH(), despite an error (no update tables specified), CURVAL() does correctly return the disk value.
>
>Is there an official way to achieve this, or must I use REFRESH(), supressing the error?
-=Gary
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform