MillBear


Hi all

The VFP database system is running in the server so that all the workstations can share it.

The user complained that she could not save the data after amending. I tested to see whether I was able to save it on my side. It works successfully. I went back to the userí»s workstation to verify it but still the same problem. I tried other workstations and found no problem so far.

Assuming that there are a few possible causes:

1) Computer in the workstation is not maintained well.

2) Email virus will affect the database system if anti-virus software cannot detect it.

3) There is file caching problem in the workstation. The workstation will "hold" certain data and then release it to the server. It could be due to this holding period where the data is not updated to the server. This could account for some
data corruption on the server.

Is there any other reasons behind this problem. Please enlighten me.

Thank you.





Re: VFP6: Problem saving data

dni


You may try to use command flush from work stations to force to save on disk all data changes (if you are not using buffering).





Re: VFP6: Problem saving data

Lightening

Does this user is on the everyone list of the network, meaning does she have to the write or change permission on the data folder on the server




Re: VFP6: Problem saving data

MillBear

 Lightening wrote:
Does this user is on the everyone list of the network, meaning does she have to the write or change permission on the data folder on the server

Yes, she is on the network list and has access to the database system for amendation/updation.

The next day, I double-checked the data on her workstation. It is existing there. Strange.
I think that something inside her pc "hold the data" before sending to the server once updating.





Re: VFP6: Problem saving data

AndyKr

>>It is existing there. Strange.
I think that something inside her pc "hold the data" before sending to the server once updating

Check the setting of the write-behind cache on the Workstation and disable it if it set. This can cause precisely these types of problems.

To check, go to the workstation and open the Hardware Properties pag (in XP you can get to it from windows explorer => click on the root directory of the disk and open Properties. Onthe Hardware tab, open Properties again and go to the Policies tab) There is a checkbox that sets Write Cacheing on/off.






Re: VFP6: Problem saving data

MillBear

Hmm, if i disable the setting of the write-behind cache, will it affect the data




Re: VFP6: Problem saving data

AndyKr

>>Hmm, if i disable the setting of the write-behind cache, will it affect the data

No. All it does is limit windows from cacheing data before it writes it to disk.

In VFP 9.0 there is an extra clause on the FLUSH command that forces an immediate disk write to avoid this problem but since you are stuck in a 10-year old, obsolete, version that is not an option for you.