>Hi Fabio,
>
>Perhaps the title for the thread should be: "I don't know how to work in multi-user environment, please help?" But, of course, it wouldn't look as cool as something like: "BUG: ... transactions incorrect!!!", would it?
Aleksey, sure on the multiuser I do not have to learn from you.
If VFPT it is not not even in a position to guaranteeing the coherence of give you to the inside of a process,
we figure ourselves between more processes.
>
>As I explained in message #
815257, VFP doesn't refresh record's content unless you ask it to. It might, but doesn't have to. There are many different factors play here, the bottom line is - if you don't make sure the record is refreshed, you shouldn't expect that VFP will always auto-magically do it for you.
The magic is the observation of phenomena of which does not know the cause.
I do not speak about magic, you use the magic word.
>
>What can be done to refresh record's content from disk:
>Option #1: Lock the record.
>Option #2: Set the second parameter of SET REFRESH to desired threshold and reread the record (GO RECNO()).
>Option #3: Discard file cache (SYS(1104)), reread the record (GO RECNO()).
>
>For this particular scenario, the following code can be used:
>
>SYS(1104,100)
>GO RECNO(100) IN 100
>
>
>Thanks,
>Aleksey.
Well, then the solution it is simple:
- you move the cache, from a workarea level to a file handle level
( then a table have a single cache only )
or implement this command:
DISABLECACHE([workaread|aliasname])
and
SET DISABLECACHE ON|OFF
Fabio