About the command "Set Exclusive Off"

Hi All,

This is Sam.
I'm now running on troubles by using the command "Set Exclusive Off".
I designed the whole system using Visual Foxpro 6.0, and complied to exe
file. For now the system has been installed to three computers, one as a
server(with exe file), and other two for clients only.
I had used so many "Index on" commands and thought to be "not shared". I
added "Set Exclusive Off" before getting into my system, and added "Set
Exclusive On" before the command "Index On" and "Set Exclusive Off" after
that.
Like this:
*****************
Set Exclusive on
select table1
use table1
index on idnumber to table1
set exclusive off
*****************
And now I'm still running on this trouble. The system can only be opened by
itself(Server), but not able for other two computers through the local area
network.

Please help,
thanks

Sam.

Bernhard
Sun Jul 03 09:50:17 CDT 2005

Hi Sam Hung

> *****************
> Set Exclusive on
> select table1
> use table1
> index on idnumber to table1
> set exclusive off
> *****************
> And now I'm still running on this trouble. The system can only be opened by
> itself(Server), but not able for other two computers through the local area
> network.

The setting of SET EXCLUSIVE is respected only at following USE commands.
Changing this setting has no effect on already opened tables. So you should add
another USE command after SET EXCLUSIVE OFF, maybe like this:

> *****************
> Set Exclusive on
> select table1
> use table1
> index on idnumber to table1
> set exclusive off
USE table1
> *****************

Regards
Bernhard Sander

Cindy
Tue Jul 05 14:40:05 CDT 2005

Hi Sam,

If you use compound indexes (CDX indexes) they will keep themselves
up-to-date automatically and you'll only need to set the order of the table:

Select 0
Use Table1 Order SomeOrder Shared

If you have maintenance routines that require exclusive use of the tables
you will need to run them when all the other users are out of the system.
This would be at night or on weekends, or, you could trigger the maintenance
with the first user and let the others get a "Please wait for maintenance to
finish" message.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Sam Hung" <SamHung@discussions.microsoft.com> wrote in message
news:B5C132F8-2762-4046-86F9-CE5B016B59F8@microsoft.com...

> *****************
> Set Exclusive on
> select table1
> use table1
> index on idnumber to table1
> set exclusive off
> *****************
> And now I'm still running on this trouble. The system can only be opened
> by
> itself(Server), but not able for other two computers through the local
> area
> network.