General information
Category:
Coding, syntax & commands
The first couple of tries, your test program did not choke on the copy
to type delimited command. But nothing would be in the test.txt file.
create cursor x1 ( i1 i, c1 c(10) )
insert into x1 values ( 1, 'test' )
copy to test.txt type DELIMITED
modi file test.txt
But since the copy to delim was working, I tried it with the offending table
which happens to be called IB2005. The first time
copy to ibAll.txt type DELIMITED
worked. Then I tried a
copy to test.txt type DELIMITED with ";"
And got the error. Now, however, this brings an error at the copy to
delim command.
create cursor x1 ( i1 i, c1 c(10) )
insert into x1 values ( 1, 'test' )
copy to test.txt type DELIMITED &&invalid path or file name
But if I do a copy command with a different file name, it works
copy to est.txt type DELIMITED &&works fine
modi file est.txt && shows the values inserted into cursor
This has me confused. I thought that the copy command was supposed to
overwrite the destination file? Is IB2005.dbf is corrupted is their a way
to repair it. In my program, IB2005 gets created by having foxpro open up
an excell worksheet, write it to a DBF file, which foxpro then opens and uses.
So the table is actually created by excel. Assuming that the file from
excel might be corrupted, I suppose I could get around that
by having excel write as csv file and then appending that into a table created
programmatically in foxpro.
Steve
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only