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?