Strange table behavior

I am using VFP 7.0 and have table that I open, zap and then append new
datafrom a delimited text file. When I do it manually from the development
environment it works ok. When it runs in my program from the IDE or stand
alone it has the old data in the table. How can that be from a zapped table?
I've put browse windows between the lines and it is empty and them appends
old data. I don't know where it is getting it. That file name does not
exist anywhere else on my system. Please help!

USE rmsmove IN 3 EXCLUSIVE
SELECT rmsmove
browse && old data
ZAP
browse && empty table
APPEND FROM .\updates\rms.full.txt DELIMITED WITH CHARACTER |
browse && old data again???
*REINDEX


Cory

Cindy
Wed Mar 29 15:44:34 CST 2006

Hi Cory,

I see you're using the "." notation to indicate your file path. Is there any
chance the current directory in your app is not the same as the current
directory when you run the code manually?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com


"Cory" <Cory@discussions.microsoft.com> wrote in message
news:7A77F59D-A9EE-4937-89CD-1546218290F8@microsoft.com...
>I am using VFP 7.0 and have table that I open, zap and then append new
> datafrom a delimited text file. When I do it manually from the
> development
> environment it works ok. When it runs in my program from the IDE or stand
> alone it has the old data in the table. How can that be from a zapped
> table?
> I've put browse windows between the lines and it is empty and them appends
> old data. I don't know where it is getting it. That file name does not
> exist anywhere else on my system. Please help!
>
> USE rmsmove IN 3 EXCLUSIVE
> SELECT rmsmove
> browse && old data
> ZAP
> browse && empty table
> APPEND FROM .\updates\rms.full.txt DELIMITED WITH CHARACTER |
> browse && old data again???
> *REINDEX
>
>
> Cory

Cory
Wed Mar 29 16:32:03 CST 2006

No, even if it was, there is not other file by that name.

"Cindy Winegarden" wrote:

> Hi Cory,
>
> I see you're using the "." notation to indicate your file path. Is there any
> chance the current directory in your app is not the same as the current
> directory when you run the code manually?
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "Cory" <Cory@discussions.microsoft.com> wrote in message
> news:7A77F59D-A9EE-4937-89CD-1546218290F8@microsoft.com...
> >I am using VFP 7.0 and have table that I open, zap and then append new
> > datafrom a delimited text file. When I do it manually from the
> > development
> > environment it works ok. When it runs in my program from the IDE or stand
> > alone it has the old data in the table. How can that be from a zapped
> > table?
> > I've put browse windows between the lines and it is empty and them appends
> > old data. I don't know where it is getting it. That file name does not
> > exist anywhere else on my system. Please help!
> >
> > USE rmsmove IN 3 EXCLUSIVE
> > SELECT rmsmove
> > browse && old data
> > ZAP
> > browse && empty table
> > APPEND FROM .\updates\rms.full.txt DELIMITED WITH CHARACTER |
> > browse && old data again???
> > *REINDEX
> >
> >
> > Cory
>
>
>

Cindy
Wed Mar 29 21:12:33 CST 2006

Hi Cory,

I'm not doubting you that there's no other file by that name, but I've seen
similar questions here and the final answer was that there _was_ another
file by that name hiding somewhere in the search path.

A couple of things to try -

Open your file in Notepad and verify that there's "new" data in it, not the
"old" data.

Remove/rename the file and run the code and see if your app complains that
it can't find the file.

You've got two dots in your file name. Try renaming the file so it has a
more standard name and see if that changes anything. Of course, change the
code to match the new file name.

Copy your text file to another name, and then open it and change something
in the first couple of lines that will make it obvious that it's the new
test file. Maybe fill a character field with "****". Now that you know
there's (really, really, really) only one file, hard code the name of the
new file into your program, and run the program. See what you get.


--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com


"Cory" <Cory@discussions.microsoft.com> wrote in message
news:1F56ADC7-AE47-42D1-999B-CBDFE9D6B886@microsoft.com...
> No, even if it was, there is not other file by that name.

>> I see you're using the "." notation to indicate your file path. Is there
>> any
>> chance the current directory in your app is not the same as the current
>> directory when you run the code manually?

>> > APPEND FROM .\updates\rms.full.txt DELIMITED WITH CHARACTER |