PRB: CURVAL() Returns Same Value as OLDVAL()
Article ID: 130299
Article Last Modified on 2/15/2002
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
This article was previously published under Q130299
SYMPTOMS
Under certain circumstances, CURVAL() and OLDVAL() return the same value.
CAUSE
This is by design. CURVAL() and OLDVAL() only return different values when
the following two conditions are both true:
- Optimistic buffering is enabled.
- Another user has modified the current record in a table while you were
editing it.
In addition, CURVAL() and OLDVAL() return the same value if the all three
of the following conditions are met:
- Two forms in the same Visual FoxPro session are using the same table.
- The data on one instance of the form has been modified.
- The data on another instance of the form has not been modified.
In this case, CURVAL() does not return a different value because the two
instances of the forms share a data session by default. Because the user
has locked the record in the first form, the data session in the second
form considers itself to have locked the record as well.
RESOLUTION
Choose one of the following threee alternatives:
Additional query words: VFoxWin multi-user
Keywords: vfoxwin kbnetwork 3.00 KB130299