Hi Fabio,

It is much easier to criticize the tool and complain that it doesn't fit your vision of the world than to learn how does it work and how to use it properly, isn't it?

Thanks,
Aleksey.



>>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