>Hmmmm. Well Kent I am not sure. The CURVAL function is *supposed* to read the record from the original table (not the locally buffered data) directly. That is the intent of it for multi user networks. I am wondering if it could be something else - and here I amm getting into stuff I don't know too well - such as needing to use a FLUSH command. Maybe the data isn't being put into the original table as fast as you think it is. Just guessing of course. Other than that I can't think of anything. HTH
>
>>In the following enviroment curval over a network will not return the correct value.
>>
>>Use native tables.
>>Buffer Mode optimistic.
>>Private data session.
>>Set Refresh to 300,300
>>
>>By turning down the refresh to 10,1 you narrow the window of a error to one second. With local views and Refresh() you can get the correct data,
>>but with native tables and no function for refreshing the tables
>>you do not get the correct value.
>>Thanks.
Thanks for your input to my questions but I have found my problem in a knowledge base article from MS. Article ID: Q190496. It appears that
with optimistic buffering seek and curval can return the wrong values.
http://support.microsoft.com/support/kb/articles/q190/4/96.asp?FR=0Kent.