what's wrong with this "copy to" line

OK, I can't figure this out. sometimes this line works and sometimes it
won;t, and from the same program. Can someone tell me what's wrong with it?
I'm using VFP7 and VFP9 and I get the error "invalid path or filename" but
the path is correct.

COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
CHARACTER "|"

If I shorten it down and put it in "C:\work" then it works fine.

Please help!

Thanks!
Buster

Bubba
Fri Dec 02 12:01:37 CST 2005

Now I just ran it again going to C:\work and it gave me "invalid path or
filename"

Is there something I need to set that I'm not setting or what?

Thanks!
Buster

"Bubba Gump Shrimp" <none@microsoft.com> wrote in message
news:einsVn29FHA.1988@TK2MSFTNGP12.phx.gbl...
> OK, I can't figure this out. sometimes this line works and sometimes it
> won;t, and from the same program. Can someone tell me what's wrong with
> it? I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
> but the path is correct.
>
> COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
> CHARACTER "|"
>
> If I shorten it down and put it in "C:\work" then it works fine.
>
> Please help!
>
> Thanks!
> Buster
>

Josh
Fri Dec 02 12:36:46 CST 2005

you need to specify a file name.


On Fri, 2 Dec 2005 13:01:37 -0500, "Bubba Gump Shrimp" <none@microsoft.com>
wrote:

>Now I just ran it again going to C:\work and it gave me "invalid path or
>filename"
>
>Is there something I need to set that I'm not setting or what?
>
>Thanks!
>Buster
>
>"Bubba Gump Shrimp" <none@microsoft.com> wrote in message
>news:einsVn29FHA.1988@TK2MSFTNGP12.phx.gbl...
>> OK, I can't figure this out. sometimes this line works and sometimes it
>> won;t, and from the same program. Can someone tell me what's wrong with
>> it? I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
>> but the path is correct.
>>
>> COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>> CHARACTER "|"
>>
>> If I shorten it down and put it in "C:\work" then it works fine.
>>
>> Please help!
>>
>> Thanks!
>> Buster
>>
>


--- AntiSpam/harvest ---
Remove X's to send email to me.

Josh
Fri Dec 02 12:36:46 CST 2005


so there's no directory named:
C:\WORK\ADHOC\SURFER\M2\INU141
just
C:\WORK\ADHOC\SURFER\M2\

right?

On Fri, 2 Dec 2005 12:57:15 -0500, "Bubba Gump Shrimp" <none@microsoft.com>
wrote:

>OK, I can't figure this out. sometimes this line works and sometimes it
>won;t, and from the same program. Can someone tell me what's wrong with it?
>I'm using VFP7 and VFP9 and I get the error "invalid path or filename" but
>the path is correct.
>
>COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>CHARACTER "|"
>
>If I shorten it down and put it in "C:\work" then it works fine.
>
>Please help!
>
>Thanks!
>Buster
>


--- AntiSpam/harvest ---
Remove X's to send email to me.

MichelRoy
Fri Dec 02 12:37:02 CST 2005

assuming the path C:\WORK\ADHOC\SURFER\M2\ exists
make sure you don't have a directory name caled INU141

or add a file extension like .TXT

"Bubba Gump Shrimp" wrote:

> Now I just ran it again going to C:\work and it gave me "invalid path or
> filename"
>
> Is there something I need to set that I'm not setting or what?
>
> Thanks!
> Buster
>
> "Bubba Gump Shrimp" <none@microsoft.com> wrote in message
> news:einsVn29FHA.1988@TK2MSFTNGP12.phx.gbl...
> > OK, I can't figure this out. sometimes this line works and sometimes it
> > won;t, and from the same program. Can someone tell me what's wrong with
> > it? I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
> > but the path is correct.
> >
> > COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
> > CHARACTER "|"
> >
> > If I shorten it down and put it in "C:\work" then it works fine.
> >
> > Please help!
> >
> > Thanks!
> > Buster
> >
>
>
>

Bubba
Fri Dec 02 13:43:53 CST 2005

Correct, there's no directory inu141 and putting "type delimited"
automatically inserts a .txt extension on it. It's very strange how
sometimes it works and sometimes it doesn't. The file name it's supposed to
be creating will be inu141.txt. Even if I put .txt on it in the command, it
makes no difference.

Any ideas?

Thanks!
Buster

"Josh Assing" <Xjosh@jassing.comX> wrote in message
news:i051p1929q1mjp9a9ld4l2k0ve1v5472do@4ax.com...
>
> so there's no directory named:
> C:\WORK\ADHOC\SURFER\M2\INU141
> just
> C:\WORK\ADHOC\SURFER\M2\
>
> right?
>
> On Fri, 2 Dec 2005 12:57:15 -0500, "Bubba Gump Shrimp"
> <none@microsoft.com>
> wrote:
>
>>OK, I can't figure this out. sometimes this line works and sometimes it
>>won;t, and from the same program. Can someone tell me what's wrong with
>>it?
>>I'm using VFP7 and VFP9 and I get the error "invalid path or filename" but
>>the path is correct.
>>
>>COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>>CHARACTER "|"
>>
>>If I shorten it down and put it in "C:\work" then it works fine.
>>
>>Please help!
>>
>>Thanks!
>>Buster
>>
>
>
> --- AntiSpam/harvest ---
> Remove X's to send email to me.

Trey
Fri Dec 02 13:56:55 CST 2005

works fine for me - with or w/o extension, w/o directory same as
filename existing (vfp9)

are you sure the target directory exists? don't eyeball it - use the
DIRECTORY() function.

IF DIRECTORY("C:\WORK\ADHOC\SURFER\M2\")
COPY TO ...
ENDIF

Bubba Gump Shrimp wrote:

>OK, I can't figure this out. sometimes this line works and sometimes it
>won;t, and from the same program. Can someone tell me what's wrong with it?
>I'm using VFP7 and VFP9 and I get the error "invalid path or filename" but
>the path is correct.
>
>COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>CHARACTER "|"
>
>If I shorten it down and put it in "C:\work" then it works fine.
>
>Please help!
>
>Thanks!
>Buster
>
>
>
>

Bubba
Fri Dec 02 14:04:29 CST 2005

I know the directory exists for a fact. As a matter of fact, just in case
there was a typo i wasn't seeing, in the command window where I opened up
the program, from the same directory, I copied the path and pasted it into
that line in the program but it still pukes.

What the hell????

"Trey Walpole" <treypole@no.spam> wrote in message
news:%23YP%23Go39FHA.252@TK2MSFTNGP15.phx.gbl...
> works fine for me - with or w/o extension, w/o directory same as filename
> existing (vfp9)
>
> are you sure the target directory exists? don't eyeball it - use the
> DIRECTORY() function.
>
> IF DIRECTORY("C:\WORK\ADHOC\SURFER\M2\")
> COPY TO ...
> ENDIF
>
> Bubba Gump Shrimp wrote:
>
>>OK, I can't figure this out. sometimes this line works and sometimes it
>>won;t, and from the same program. Can someone tell me what's wrong with
>>it? I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
>>but the path is correct.
>>
>>COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>>CHARACTER "|"
>>
>>If I shorten it down and put it in "C:\work" then it works fine.
>>
>>Please help!
>>
>>Thanks!
>>Buster
>>
>>

Bubba
Fri Dec 02 14:24:42 CST 2005

ok, well that got it working for some reason. Why I don't know but it works
so that's good.

Thanks for your idea!
Buster

"Trey Walpole" <treypole@no.spam> wrote in message
news:%23YP%23Go39FHA.252@TK2MSFTNGP15.phx.gbl...
> works fine for me - with or w/o extension, w/o directory same as filename
> existing (vfp9)
>
> are you sure the target directory exists? don't eyeball it - use the
> DIRECTORY() function.
>
> IF DIRECTORY("C:\WORK\ADHOC\SURFER\M2\")
> COPY TO ...
> ENDIF
>
> Bubba Gump Shrimp wrote:
>
>>OK, I can't figure this out. sometimes this line works and sometimes it
>>won;t, and from the same program. Can someone tell me what's wrong with
>>it? I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
>>but the path is correct.
>>
>>COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>>CHARACTER "|"
>>
>>If I shorten it down and put it in "C:\work" then it works fine.
>>
>>Please help!
>>
>>Thanks!
>>Buster
>>
>>

Bubba
Fri Dec 02 14:28:57 CST 2005

ok now, I just figured out one problem. When it tries to write to the
directory, if that file already exists, it pukes with "invalid path...". If
I remove the file, it works. What do I need to change in my Fox config? I've
got safe set to off at the top of the program.

Thanks!

"Trey Walpole" <treypole@no.spam> wrote in message
news:%23YP%23Go39FHA.252@TK2MSFTNGP15.phx.gbl...
> works fine for me - with or w/o extension, w/o directory same as filename
> existing (vfp9)
>
> are you sure the target directory exists? don't eyeball it - use the
> DIRECTORY() function.
>
> IF DIRECTORY("C:\WORK\ADHOC\SURFER\M2\")
> COPY TO ...
> ENDIF
>
> Bubba Gump Shrimp wrote:
>
>>OK, I can't figure this out. sometimes this line works and sometimes it
>>won;t, and from the same program. Can someone tell me what's wrong with
>>it? I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
>>but the path is correct.
>>
>>COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>>CHARACTER "|"
>>
>>If I shorten it down and put it in "C:\work" then it works fine.
>>
>>Please help!
>>
>>Thanks!
>>Buster
>>
>>

cindy_winegarden
Fri Dec 02 14:36:02 CST 2005

Hi Buster,

It works ok for me with directory:
C:\Work\AdHoc\Surfer\M2

And command:
COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" ;
TYPE DELIMITED WITH "" WITH CHARACTER "|"

Sorry I can't duplicate your problem. My advice is to completely retype the
line of code using the address from the address bar in Explorer. Sometimes
code acts like there are odd non-printing characters embedded in code, and
they go away when the line is retyped.


--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Bubba Gump Shrimp" wrote:

> OK, I can't figure this out. sometimes this line works and sometimes it
> won;t, and from the same program. Can someone tell me what's wrong with it?
> I'm using VFP7 and VFP9 and I get the error "invalid path or filename" but
> the path is correct.
>
> COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
> CHARACTER "|"
>
> If I shorten it down and put it in "C:\work" then it works fine.
>
> Please help!
>
> Thanks!
> Buster
>
>
>

Bubba
Fri Dec 02 14:41:57 CST 2005

Cindy, as I stated a couple of posts above, we have it working. However, if
that file is already sitting in the directory, it gives the error and I have
"set safe off". If I delete the file, then the command works fine.

Advise?

Thanks!

"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:6E6C5B31-E201-4A5B-992C-D520B5BCC95B@microsoft.com...
> Hi Buster,
>
> It works ok for me with directory:
> C:\Work\AdHoc\Surfer\M2
>
> And command:
> COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" ;
> TYPE DELIMITED WITH "" WITH CHARACTER "|"
>
> Sorry I can't duplicate your problem. My advice is to completely retype
> the
> line of code using the address from the address bar in Explorer. Sometimes
> code acts like there are odd non-printing characters embedded in code, and
> they go away when the line is retyped.
>
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "Bubba Gump Shrimp" wrote:
>
>> OK, I can't figure this out. sometimes this line works and sometimes it
>> won;t, and from the same program. Can someone tell me what's wrong with
>> it?
>> I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
>> but
>> the path is correct.
>>
>> COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
>> CHARACTER "|"
>>
>> If I shorten it down and put it in "C:\work" then it works fine.
>>
>> Please help!
>>
>> Thanks!
>> Buster
>>
>>
>>

cindy_winegarden
Sun Dec 04 13:20:02 CST 2005

Just check for the file (If File()) and Erase it if it's there. Then do the
Copy operation.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Bubba Gump Shrimp" wrote:

> Cindy, as I stated a couple of posts above, we have it working. However, if
> that file is already sitting in the directory, it gives the error and I have
> "set safe off". If I delete the file, then the command works fine.
>
> Advise?
>
> Thanks!
>
> "Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
> news:6E6C5B31-E201-4A5B-992C-D520B5BCC95B@microsoft.com...
> > Hi Buster,
> >
> > It works ok for me with directory:
> > C:\Work\AdHoc\Surfer\M2
> >
> > And command:
> > COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" ;
> > TYPE DELIMITED WITH "" WITH CHARACTER "|"
> >
> > Sorry I can't duplicate your problem. My advice is to completely retype
> > the
> > line of code using the address from the address bar in Explorer. Sometimes
> > code acts like there are odd non-printing characters embedded in code, and
> > they go away when the line is retyped.
> >
> >
> > --
> > Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> > cindy_winegarden@msn.com www.cindywinegarden.com
> > Blog: http://spaces.msn.com/members/cindywinegarden
> >
> >
> > "Bubba Gump Shrimp" wrote:
> >
> >> OK, I can't figure this out. sometimes this line works and sometimes it
> >> won;t, and from the same program. Can someone tell me what's wrong with
> >> it?
> >> I'm using VFP7 and VFP9 and I get the error "invalid path or filename"
> >> but
> >> the path is correct.
> >>
> >> COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH
> >> CHARACTER "|"
> >>
> >> If I shorten it down and put it in "C:\work" then it works fine.
> >>
> >> Please help!
> >>
> >> Thanks!
> >> Buster
> >>
> >>
> >>
>
>
>