Question about XBROWSE

[Enrico Maria Giordano]

Yes, it is the controlling index. It must have something to do with the nature of a temporary index.

So try without TEMPORARY clause and let me know.

EMG

[Randal]

Gale:

Interesting thread, thanks for your comments and testing.

Do you think it's safe to use cmxShared(.f.) to load records into a browse or array and then call cmxShared(.t.) after they are loaded?

Using cmxShared(.f.) doesn't appear to effect the ability to lock and update a record in a multi-user environment.

What kind of problems might one encounter doing this?

Thanks,
Randal

[Gale FORd]

My understanding is that with the dirty read turned on ( cmxShared(.f.) ) then you might skip to an invalid record or a seek would show found() but the data does not match.
The speed difference on a network drive is really tempting but I am very careful with this option.
I have tried to put history data in another database so I could use this option. Current and constant changing records are another story.