Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 Tags
Subject: RE: zap
Thread ID: 143229 Message ID: 143616 # Views: 1 # Ratings: 2
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, August 30, 2007 10:44:05 AM         
   


> >
> > Because you obviously have the tables open BEFORE you issued SET EXCLUSIVE ON (you are using SELECT myfile1 and SELECT myfile2 which does not actually open the tables) - presumably the first was already exclusive, but the second was not.
> >
> > Remember that changing the setting of EXCLUSIVE does not affect anything that is ALREADY open - it only affects things explicitly opened after the setting changed - which is why Mike's solution works and your didn't.
> >
> > Regards
> > Andy Kramek
> > Microsoft MVP (Visual FoxPro)
> > Tightline Computers Inc, Akron Ohio, USA
>
>
>
> Andy,
>
> In fact the command 'set exclusive on' is allready in the main programm. And nowhere
> there is a 'set exclusive off'
> I do not want to spend a lot of time to it. I use now 'delete all' instead.
> I know the concequenses of that.
>
> Rob

Rob

SET EXCLUSIVE is scoped in a datasession and each form can have its own datasession. So even if you give set exclusive on in the main program, the form may have SET EXCLUSIVE OFF.

Regards
Tushar

ENTIRE THREAD

zap Posted by Rob @ 8/26/2007 1:41:36 PM
RE: zap Posted by Mike Gagnon @ 8/26/2007 2:18:12 PM
RE: zap Posted by Rob @ 8/27/2007 1:50:26 PM
RE: zap Posted by Andy Kramek @ 8/27/2007 2:30:39 PM
RE: zap Posted by Rob @ 8/30/2007 10:41:30 AM
RE: zap Posted by tushar @ 8/30/2007 10:44:05 AM
RE: zap Posted by Rob @ 8/30/2007 11:26:19 AM
RE: zap Posted by Rob @ 9/3/2007 6:17:17 PM
RE: zap Posted by Ken Murphy @ 9/3/2007 6:37:03 PM
RE: zap Posted by Rob @ 9/3/2007 7:09:05 PM
RE: zap Posted by Ken Murphy @ 9/4/2007 1:19:09 AM
RE: zap Posted by Andy Kramek @ 8/30/2007 1:07:00 PM
RE: zap Posted by Rob @ 8/30/2007 7:58:17 PM
RE: zap Posted by Massimo Tombesi @ 8/27/2007 2:50:51 PM
RE: zap Posted by Cetin Basoz @ 8/30/2007 1:19:23 PM