To All, Just an aside to copying files. If you use Winzip you can copy files that are open in VFP with no problem even though you get a "warning".
I have done this on many occasions when I needed to take example data off site without closing the sorkstations down and is a lifesaver if you are desperate for a copy of a table. This assumes of course the users are not writing to the file exactly during the copy in which case you will "probably" loose the updated record(s) as Winzip seems to take a snapshot of the table/file once it opens it for compression. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: 04 July 2007 10:05 To: [email protected] Subject: Re: Simultaneous Copying?? Ken Dibble wrote: > Doesn't copying a flat file imply a lock on that file until the copying is > done? Or am I completely misunderstanding how this works? > At a guess VFP only concerns itself with locking for database operations. What you're doing with copy file is essentially telling the OS to copy it. So if the file didn't exist in the target location to begin with then whichever workstation gets in first in the queue will begin copying, and the other will lock out until the first is finished. I'm not sure that SET SAFETY affects COPY FILE at all. So it's a 'last in wins' situation. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
