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?
TIA
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
_______________________________________________
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/53B5710D.9070306@san-dc.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.
In short the answer is no, no and thrice NO. The file being open means you will either get a sharing error or if it does manage the copy then you may well get file corruption and the integrity of the file/table will be in question.
Web server will act no different to a standard file server when it comes to file usage.
Why not at a small web app to export the data in xml or csv format. That way you can be sure that the data you transfer is correct?
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Jeff Johnson
Sent: 03 July 2014 16:05
To: profox@leafe.com
Subject: Copy DBF that is open
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?
TIA
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
[excessive quoting removed by server]
_______________________________________________
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/18725B8CD2D5D247873A2BAF401D4AB22A522E31@EX2010-A-FPL.FPL.LOCAL
** 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.
Just try it and you will know the result! :)
My bet: the file would be locked when it's opened by Foxpro (shared or
exclusive).
On 3 July 2014 23:04, 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?
--
.~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!
_______________________________________________
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/CAGv=MJBWNOrnGcVO5rJzhFMxC-bO9zqmiHe2gfyjufcKLPJRwg@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.
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
--- 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.
----- Original Message -----
From: "Man-wai Chang" <changmw@gmail.com>
To: "ProFox Email List" <profox@leafe.com>
Sent: Thursday, July 03, 2014 5:32 PM
Subject: Re: Copy DBF that is open
> Just try it and you will know the result! :)
>
> My bet: the file would be locked when it's opened by Foxpro (shared or
> exclusive).
>
> On 3 July 2014 23:04, 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?
>
>
> --
> .~. Might, Courage, Vision. SINCERITY!
> / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
> /( _ )\ http://sites.google.com/site/changmw
> ^ ^ May the Force and farces be with you!
>
[excessive quoting removed by server]
_______________________________________________
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/9B8BBBA03C174CEA88691143E5871BE3@MuriellePC
** 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.
I do it all the time no problems
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Gérard
Lochon
Sent: Thursday, July 03, 2014 12:37 PM
To: profoxtech@leafe.com
Subject: Re: Copy DBF that is open
----- Original Message -----
From: "Man-wai Chang" <changmw@gmail.com>
To: "ProFox Email List" <profox@leafe.com>
Sent: Thursday, July 03, 2014 5:32 PM
Subject: Re: Copy DBF that is open
> Just try it and you will know the result! :)
>
> My bet: the file would be locked when it's opened by Foxpro (shared or
> exclusive).
>
> On 3 July 2014 23:04, 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?
>
>
> --
> .~. Might, Courage, Vision. SINCERITY!
> / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
> /( _ )\ http://sites.google.com/site/changmw
> ^ ^ May the Force and farces be with you!
>
[excessive quoting removed by server]
_______________________________________________
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/00bb01cf96dd$7cf259b0$76d70d10$@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.
----- Original Message -----
From: "Man-wai Chang" <changmw@gmail.com>
> Just try it and you will know the result! :)
>
> My bet: the file would be locked when it's opened by Foxpro (shared or
> exclusive).
Adding to this, VFP may have bufferized data somewhere in the memory,
and your file then won't be the exact reflect of the intantaneous situation.
So, no.
_______________________________________________
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/BA576988B6544FA5AC1F9A26F526DE17@MuriellePC
** 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.
On Thu, Jul 3, 2014 at 10: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?
>
> ----------------
If on a web server why not make it a file that a browser could consume?
Copy to XLS makes the first cut for me.
If you are just consuming that dame dbf somewhere else and passing it
through the intertubes just come in as another shared user to copy to a
different named table. FTP it and clean up web server's temp copy when
done.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- 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/CAJidMY+1JUQ7AryEXf1m1EYBqH6dEV=ao5bEM80T+b=FiK=f-A@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.
Use an sql select into a new table,,, Copy that table to server, rename
it on the way.
Mike
On 03/07/2014 12:43 PM, Stephen Russell wrote:
> On Thu, Jul 3, 2014 at 10: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?
>>
>> ----------------
>
>
> If on a web server why not make it a file that a browser could consume?
>
> Copy to XLS makes the first cut for me.
>
> If you are just consuming that dame dbf somewhere else and passing it
> through the intertubes just come in as another shared user to copy to a
> different named table. FTP it and clean up web server's temp copy when
> done.
>
>
_______________________________________________
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/53B58ACF.8080208@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.
Stephen: I neglected to say that I have no access to the web server and
have a DBA working the keys for me.
On 7/3/2014 9:43 AM, Stephen Russell wrote:
> On Thu, Jul 3, 2014 at 10: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?
>>
>> ----------------
>
>
> If on a web server why not make it a file that a browser could consume?
>
> Copy to XLS makes the first cut for me.
>
> If you are just consuming that dame dbf somewhere else and passing it
> through the intertubes just come in as another shared user to copy to a
> different named table. FTP it and clean up web server's temp copy when
> done.
>
>
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
_______________________________________________
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/53B58AF4.2020004@san-dc.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.