Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Massimo Tombesi
  Where is Massimo Tombesi?
 
 Italy
 Massimo Tombesi
 To: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 Tags
Subject: RE: zap
Thread ID: 143229 Message ID: 143294 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, August 27, 2007 2:50:51 PM         
   


> In one procedure:
>
> set exclu on
> set safety off
>
> select myfile1
> zap
>
> select myfile2
> zap
>
> zap myfile1 gives no problems
> zap myfile2 gives an error: file must be opened exclusive.
>>
> zap first myfile2 gives the same error.
> set exclu off gives the same result.
> So I think it must be something in the table itself, but don't know what.
>
> ???????
> Rob


Perhaps because SET EXCLUSIVE can't change the status of previously opened tables, like that you are SELECTing. This may happen when you SELECT a table that is already open with the clause Exclusive=.F., for example in the dataenvironment of a form. If this is the case, you have to issue SET EXCLUSIVE ON before opening the table (or in the dataenvironment), and not just before you SELECT it.

Massimo Tombesi

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