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


> > Hello all
> >
> > 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.
> >
> > Both files are in a DBC
> > Both files have exact the same structure. But myfile2 is ONE bit greater the myfile1
> > ???????
> >
> >
> > Nice day
> >
> > Rob
>
> Try:
>
> use myfile1 exclusive in 0
> select myfile1
> zap
>
> use myfile2 exclusive in 0
> select myfile2
> zap
>
> Mike Gagnon
>


Mike,

This will work for sure. No need to try. But I want to know why myfile1 gives no problems,
and myfile2 does.

Rob

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