>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