Borislav,
Yes, users do attampt to write to the file simultaniously as it is in any multi-users environment.
The suggestion you have definitely seems to be a solution to my problem.
I am gonna try that out.
The other thing is that, in my VFP options, I had the buffering set to off.
I wonder if that has any bearing on the saving.
Does VFP have issues in saving records in multi-user environment when the number of users reach to certain count or when the file size reaches certain number or record number reaches certain number? I know the VFP capacities but just wondering.
Which one is more of a common solution Client/Server or application accessing a centralized database from various workstations, when it comes to multi-user environment in VFP?
Thanks again for the reply,
Dawa
Sorry I was not read the help carefuly,
Is it possible some users to try to write records simultaniously?
May be the cikle will prevent lose data.
m.gnError = 0 on error m.gnError = error()BEGIN TRANSACTION....DO WHILE .NOT. FLOCK() && You decide how many cikles to waitENDDOINSERT .....TableUpdate(.t., "Stafile") && Just in case :o)if m.gnError = 0 end transaction else rollback endif
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature