dBASE Programming - COPY to CD problems.

This is Interesting: Free IT Magazines  
Home > Archive > dBASE Programming > May 2005 > COPY to CD problems.





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author COPY to CD problems.
Bob Buchanan

2005-05-19, 5:50 pm

Have a continual problem over the past few years with clients that backup
from my system to CD-RW's. Once they format using WinXP, they can drag files
from their hard drive to the newly formatted CD -- however, when my program
executes a COPY TABLE command to that same CD, an Error message occurs.
Difference machines will give different error message - but essentially,
they say, "Can't write to this CD". Other clients backup to CD-RW's with no
problems.

It seems that the formatting in XP Home and Pro comes from Roxio - or so I
have read. I purchased Roxio 6 and that seems to help -- somewhat. Roxio
tells me that once formatted, they place a little routine on the CD that
allows it to work on any other drive. Not true. It should say, it will
sometimes work and sometimes it won't.

The COPY TABLE from my system will properly backup to Diskette, Hard Drive,
Zip Drive, Flash drive -- or most any media other than be consistent with a
CD-RW. We are even doing things like having my program back up to hard
drive, then writing a DOS batch file with desktop icon to then move it from
there to the CD.

Was wondering if anyone else is running into this problem - and it they have
found a solution?

I appreciate your feedback.

Regards, Bob

Robert Buchanan
RLB & Associates
ww.rvspacemanager.com


Robert Bravery

2005-05-19, 5:50 pm

HI,

I don't have a solution, but I am trying to write a program that will be
able to do data backups to cd/dvd.
But I am having problems with the api and ocx. Currently I am trying to use
the SDK from Nero.
If and when I get it right, I will let you know.

Not much help to you now tho,

Robert

"Bob Buchanan" <rlbuch@compuserve.com> wrote in message
news:KsAxfyJXFHA.320@news-server...
> Have a continual problem over the past few years with clients that backup
> from my system to CD-RW's. Once they format using WinXP, they can drag

files
> from their hard drive to the newly formatted CD -- however, when my

program
> executes a COPY TABLE command to that same CD, an Error message occurs.
> Difference machines will give different error message - but essentially,
> they say, "Can't write to this CD". Other clients backup to CD-RW's with

no
> problems.
>
> It seems that the formatting in XP Home and Pro comes from Roxio - or so I
> have read. I purchased Roxio 6 and that seems to help -- somewhat. Roxio
> tells me that once formatted, they place a little routine on the CD that
> allows it to work on any other drive. Not true. It should say, it will
> sometimes work and sometimes it won't.
>
> The COPY TABLE from my system will properly backup to Diskette, Hard

Drive,
> Zip Drive, Flash drive -- or most any media other than be consistent with

a
> CD-RW. We are even doing things like having my program back up to hard
> drive, then writing a DOS batch file with desktop icon to then move it

from
> there to the CD.
>
> Was wondering if anyone else is running into this problem - and it they

have
> found a solution?
>
> I appreciate your feedback.
>
> Regards, Bob
>
> Robert Buchanan
> RLB & Associates
> ww.rvspacemanager.com
>
>



evilaro

2005-05-19, 5:50 pm

Meeeeeeeeeeeeee toooooooooooooo

Emilio


Bob Buchanan

2005-05-20, 2:47 am

Thanks, Robert . . .

In the meantime, I'm going to just running the DOS command from within my
program:

xPath = "D:\" // Set in the Preferences of my system.

RUN COPY customer.dbf &xPath

On all machines I've installed the system on that use CD-RW, the user has
been able to format using XP and then backup the files using DOS -- or a
drag or copy in WinExplorer or My computer. However, the dBASE COPY TABLE
command goes south most of the time. Have seen a few articles that call this
going "straight through" the program vs. via dos.

Yes, I would be curious as to what you come up with. Thanks.


"Robert Bravery" <me@u.com> wrote in message
news:okSPhoLXFHA.1760@news-server...
> HI,
>
> I don't have a solution, but I am trying to write a program that will be
> able to do data backups to cd/dvd.
> But I am having problems with the api and ocx. Currently I am trying to
> use
> the SDK from Nero.
> If and when I get it right, I will let you know.
>
> Not much help to you now tho,
>
> Robert
>
> "Bob Buchanan" <rlbuch@compuserve.com> wrote in message
> news:KsAxfyJXFHA.320@news-server...
> files
> program
> no
> Drive,
> a
> from
> have
>
>



Bob Buchanan

2005-05-20, 2:47 am

Hello again on this same issue:

If I use the dBASE RUN command to back up files to a CD, is there any way to
hide the DOS window?

Thanks . . .

Regards, Bob

Robert Buchanan
RLB & Associates
www.rvspacemanager.com


Bob Buchanan

2005-05-21, 5:48 pm

Robert . . .

Well - with no other input, I just used the RUN command with the DOS COPY
command. It was pretty ugly at first because of the DOS windows that open.
There must be a way to hide those windows but I couldn't figure how.

First I thought of putting all the copy commands in a .BAT file (so there
would only be one Window to deal with) - but couldn't figure how to get the
variable path from the users Preferences passed as a parameter. Can you pass
a parameter to a batch file? I couldn't remember. Without knowing how to do
that, I did a RUN COPY for each of about 20 or so files -- and that was a
lot of DOS windows for the user to look at bouncing around on the screen.

So I then created a topMost form to cover all that mess up -- and placed my
logo, a backup progress bar, and some tidbits of wisdom on the virtues of
backing up each day on it to fool the user into thinking it had a purpose
other than to hide some otherwise sloppy programming.

Bottom line, though, if a user can R/W files via Dos or Windows to a CD - my
program will backup to that CD.

Regards, Bob
RLB & Associates
www.rvspacemanager.com

"Robert Bravery" <me@u.com> wrote in message
news:okSPhoLXFHA.1760@news-server...
> HI,
>
> I don't have a solution, but I am trying to write a program that will be
> able to do data backups to cd/dvd.
> But I am having problems with the api and ocx. Currently I am trying to
> use
> the SDK from Nero.
> If and when I get it right, I will let you know.
>
> Not much help to you now tho,
>
> Robert



Mervyn Bick

2005-05-22, 5:48 pm

On Sat, 21 May 2005 19:29:43 +0200, Bob Buchanan <rlbuch@compuserve.com>
wrote:

<snip>
> First I thought of putting all the copy commands in a .BAT file (so there
> would only be one Window to deal with) - but couldn't figure how to get
> the
> variable path from the users Preferences passed as a parameter. Can you
> pass
> a parameter to a batch file? I couldn't remember. Without knowing how to
> do that, I did a RUN COPY for each of about 20 or so files -- and that
> was a
> lot of DOS windows for the user to look at bouncing around on the screen.


<snip>

One can pass up to 10 parameters to a batch file using %0 to %9. See the
Windows OLH batch files->replaceable parameters in. Alternatively, what
about using file() to write whatever you need to a .bat file each time
before runnng it?

Mervyn

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2009 webservertalk.com