Like Jim said, look at CURVAL(). You may be in a position where you have to write a save-brokering routine with CURVAL(), OLDVAL() and whatnot to ensure that whatever contention strategy you want to adhere to is repsected.


>I have a network and data are updated from another pc.
>
>I need to get a field value from table direct from disk not from buffer. I put SET REFRESH TO 1 and some times the value I see it's from the buffer an it's different.
>
>Example:
>
>today's date --> {14/01/1999}
>
>PC1: Update field
>
>REPLACE Table.Field1 WITH {15/01/1999}
>
>PC2: Get Value
>
>? Table.Field1
>
>it returns {14/01/1999}