I finally got the chance to try some of the excellent suggestions per my
question.
The results:
Setting whileopt had no effect. There weren't any while loops in the
program but I thought I'd give it a try anyway.
Manually disconnecting from the database before running the program had no
effect.
Trying to copy other types of files had no effect.
My SCRATCH variable was already set to the C:\TEMP. I include this in my
RBASE.DAT file from a suggestion several months ago from the list.
Per the rights issue I am the full administrator/owner on both systems. The
only difference between the two is that one is running NT 4.0 Workstation
and the other is running Win2K Pro.
Trying the PAUSE and SET ECHO ON command gave no insights or results.
The only thing that did work was the following code using the ZIP command to
call a batch file that I use to update the database.
CLEAR ALL VAR NOW
--
SET VAR vstart_time TIME = .#TIME
--
SET VAR vcomspec = (ENVVAL('COMSPEC'))
--
ZIP &vComSpec /C db_bkup
--
SET VAR vstop_time TIME = .#TIME
--
OUTPUT PRINT
--
SHOW VAR %time%
--
OUTPUT SCREEN
--
QUIT
FWIW this is the contents of the batch file:
XCOPY K:\RBASE\DATA\*.RB* D:\RBASE\DATA
EXIT
Any time I try to tackle a problem like this I am reminded of one of my
favorite quotes:
It's axiomatic that what one learns in pursuit of a goal is often more
valuable than what is gained by its attainment. "Success," said Elbert
Hubbard, "consists in the climb."
Thanks to all who provided the suggestions.
Mike Ramsour
-----Original Message-----
From: Troy Sosamon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 6:30 PM
To: [EMAIL PROTECTED]
Subject: RE: Copy question -- continued
Mike,
I posted to someone else about checking to make sure you are not staying
connected to the database because of some cachine on the workstation.
You might also want to use "Zip Xcopy" or "Zip Ncopy" (on Novell) for your
speed tests. I am not sure on NT if you will see any differences between
copy
and xcopy, but it worth a try. If you are on a Novell Network, using Ncopy
will make a big difference copy a database on a server or between servers
because it does the copy at the server instead from the workstation.
Troy
>===== Original Message From [EMAIL PROTECTED] =====
>Let's try this again.
>
>I have a program that I use to gauge the time it takes to copy a large
>database (1 GB) from one computer to another.
>
>Here is the code:
>
>DISCONNECT
>--
>PAUSE 1
>--
>SET VAR vstart_time TIME = .#TIME
>--
>COPY K:\RBASE\DATA\PMISDATA.* D:\RBASE\DATA
>--
>SET VAR vstop_time TIME = .#TIME
>--
>OUTPUT PRINT
>--
>SHOW VAR %time%
>--
>OUTPUT SCREEN
>--
>QUIT
>
>The curious problem I have encountered is that if I simply type RUN
>COPYTEST.PRG at the R> I immediately get an error that says "Cannot create
>destination file" and the program terminates. If I TRACE the command file,
>though, it runs just fine. I am copying from a Windows 2000 system to a
>Windows NT Workstation 4.0 system. Plenty of memory and disk space, etc.
I
>have tried this with different databases with the same result. I am
running
>the latest version of R:Base for Windows 6.5++.
>
>Any ideas why RUN doesn't work while TRACE does? Any way to work around
it?
>
>Thanks -- Mike Ramsour
>
>p.s. I just began using the SET ClipBoard command and man do I love it!
>The LISTOF and ITEMCOUNT are "Glorious" too. Continued thanks and
accolades
>to Razzak and the Dream Team.
>
>
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
Troy Sosamon
Denver Co
[EMAIL PROTECTED]
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
