Re: Copy DBF that is open

Author: Ted Roche

Posted: 2014-07-03 at 10:33:20

On Thu, Jul 3, 2014 at 11:04 AM, Jeff Johnson <jeff@san-dc.com> wrote:

> I want to make sure I know the answer to this before proceeding. I have

> dbfs on a web server. There are users that have the table open shared. I

> want to grab a copy of the dbf, cdx and fpt. Can I just do a Windows

> Explorer copy & paste without issue?

>

Yeah, you know the answer: both the OS and FoxPro conservatively want to

lock the entire file before copying.

SELECT * FROM source INTO TABLE extract

then re-create the indexes as needed.

Note that you'll lose the deleted records under some conditions. That you

also know.

--

Ted Roche

Ted Roche & Associates, LLC

http://www.tedroche.com

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CACW6n4vV3W8b1sHG2mWUCY9m4xfLgZ3w_KiS0w=pUH27nja6cw@mail.gmail.com

** 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.

©2014 Ted Roche