Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oldval and curval
Message
From
14/05/1997 23:09:00
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
14/05/1997 15:08:38
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00032272
Message ID:
00032365
Views:
33
>when I use oldval("x", "y"), return .NULL. x = field name and y=table name. Optimistic table buffering is on and set multilocks on.
>when I use curval("x", "y"), also return .NULL.
>
>Thanks.
>
>Jennifer
Curval is there to check to see if anyone else has changed the field value since you retrieved the information (which is maintained by oldval). If you change the field and issue a tableupdate and oldval is not equal to curval, then you will be advised that the field was changed and ask you to overwrite.

Time line example...

1)You get field information ........... oldval ="Smith"
.......... time=t

2)Someone else gets field, changes and saves....... curval = "Smythe"
..................................... time=t+x

3)You try to save your value= "Smither"
...................................................................time= t+x+y

Hope this helps//:^)
L.A.Long
ProgRes
lalong1@charter.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform