>>>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//:^)
>
>Larry
>
>I want to know why it return .null. instead of the value of the field.
>
>
>Thanks
>
>Jennifer
When you append a new record all fields are .null. until you save a value to it. If you have buffering enabled then curval and oldval will show .null. until you do a tableupdate.