FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Question about XBROWSE
Posts: 9022
Joined: Thu Oct 06, 2005 08:17 PM

Re: Question about XBROWSE

Posted: Fri Oct 01, 2010 07:47 PM
Gale FORd wrote: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
Posts: 284
Joined: Mon Oct 24, 2005 08:04 PM

Re: Question about XBROWSE

Posted: Wed Oct 06, 2010 03:50 PM

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

Posts: 663
Joined: Mon Dec 05, 2005 11:22 PM

Re: Question about XBROWSE

Posted: Wed Oct 06, 2010 05:52 PM

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.

Continue the discussion