Last time I became very proud of myself, though I know almost everything, clever and so on
God saved me punishment, I did not predicted, it was not difficalt, it was not smart, it was stupid for first class pupil.
One time in 1997 in one of my VFP3 big systems worked for 40-45 users
simultaniously I saw 'flying plate'
One of the records in grid has fake tween, I was not able to navigate through it. I did reindex, tween disappeared, I did not see such 'flying flates' later and have fogotten about it
And now plate sat on my old heard and pushed me to think agains god (VFP) .
Here is the simples situation
Bufferring 3
Active index ( set order) to the index , bult on character field( for exapmple-employee-last.name
There is grid on the form to navigate, few fields with controlsource
button to save record with =tableupdate(.f.,.t.)
Did exe and ran two samples. Edited one and the same record and saved it
The fake tween appeared in grid, navigation trough it was not possible
The destruction was not in the data , it was in index contents, reindex
killed problem.
This problem does not exist for buf5, views and indeses, built on
numeric and integer fields
Using rlock before =tableupdate and unlock later, transactions
set order to nothing and set order to oldindex after =tableupdate
did not fix trouble. Shame on my old heard, I don't know something very simple after 4.5 years in VFP, doing 12 big projects, I am still child. Thanks, if somebody will see same flying plate and will tell me that I am not last fool in the world.
Best wishes, Vladimir Zhuravlev
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.