Mike
I haven't followed this thread well, but I was
wondering a few things.
What version of RBase are you using?
Do you own RSCOPES-SHARECPY?
If you are using 6.5++ and you have RSCOPE-SHARECPY
then I might offer you another option. I created a
small VB app that runs RSCOPE-SHARECPY copying
databases from one location to another that you
can designate. If you are interested then
contact me directly at [EMAIL PROTECTED]
Jim
--- Ramsour Mike <[EMAIL PROTECTED]> wrote:
> 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/
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.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/
