Copying opened tables from FoxPro

[Dabase]

Hi,

Is there any way of copying opened FoxPro tables to another location?

Any help on this will be much appreciated.



Thanks
Dabase

 

[Mike Gagnon]

The DOS copy file will copy opened tables. Just create a batch file that will copy you open tables (and indexes).

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Dabase,

Another way of doing it is with SELECT. For example:

SELECT * FROM SourceTable INTO TABLE d:\data\TargetTable

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[Stella740pl]

You can use COPY TO - if a table is opened by you.

COPY TO D:\NewLocation\NewName WITH CDX

I someone else (or another application) holds it open, then you can use DOS commands, as Mike Gagnon suggested.

 

[Stella740pl]

Oh, and if someone else has the file opened exclusively, it appears that even DOS wouldn't help.

 

[torturedmind]

dabase,

i use WSH's CopyHere and it works on dbf's opened exclusively, too. i also learned this from the great tipmasters of this great forum. so here's a sample code:

function wincopy
parameter fldrsource, fldrtarget
ParentFolder = fldrtarget
objShell = CreateObject("Shell.Application")
objFolder = objShell.NameSpace(ParentFolder)
objFolder.CopyHere(fldrsource, 16 + 64)

you can call it something like this:

=wincopy("\\SourcePC\WrkDir\VFP6\CardLog.*", "c:\XTemp")

take note that the folder XTemp should exist prior to calling the function.

i hope this helps. peace!

kilroy
philippines

"Illegitimis non carborundum!"
-Gen. Joseph Stilwell

 

[baltman]

Kilroy,

I get an error when I try to copy an exclusively used table using your code.

I believe that there is NO WAY to copy or otherwise access an exclusively used table other that through the instance of VFP using the table.

Brian

 

[torturedmind]

sir brian,

that is strange because we have a commercial app, which i believe was written in VB that came along with our door access units, that also accesses a VFP table exclusively thru ODBC (i linked this VFP table to an MSAccess database). i said exclusively because whenever i try to open the table in VFP environment, shared or otherwise, it gives me a "File access denied." error message. but still, i can copy it using the code above. or maybe the table is not really opened exclusively by VB. i dunno cuz i don't have the codes of that VB app. hmmm... strange. maybe someone could explain?

peace!

kilroy
philippines

"Illegitimis non carborundum!"
-Gen. Joseph Stilwell

 

[torturedmind]

forgot to mention, i use vfp6 on a win98se environment. the vfp table, together with the MSAccess database where it is linked to, resides in a Novell 4 server.

kilroy
philippines

"Illegitimis non carborundum!"
-Gen. Joseph Stilwell