>Hi Al,
>From the description of the problem it is obvious that client 2 is reading from their local cache and not from the server HDD.
>
>>>>Hi,
>>>>The other client is reading the local cache, is disk caching disabled on the client ?
>>>>
>>>>>Hi,
>>>>>I have a report about next problem.
>>>>>Database located on fileserver. The client change the stock value and program make FLUSH. Then - on the server - we check the data - and new value appears. Then another cient in network - try to read this record and he getting OLD value. It seems data somewere buffered in netowrk.. but where and how to flush it?
>>>>>
>>>>>Thanks
>>>>>Denis
>>>
>>>Hi Neil,
>>>You mean - options in Windows Device Manager, HDD, Properties? There exist option to permit cache for write operations..
>>
>>Before you mess around with these settings, have you taken Michael Cummings' advice? In multi-user xBASE, the only way you can be guaranteed to be reading current data is to obtain an RLOCK() on the row you need (or an FLOCK() on the table).
I believe an explicit locking approach should be tested first. Why penalize all VFP and non-VFP apps running on the workstation by turning off disk caching, if it turns out to be unnecessary?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up