Hi Steve!
Are you sure the REMOVE TABLE command is issued? It looks like you end up in the \MYDIR\MYFILES folder when you test for the file 'MYDIR\MYFILES\DIR.TXT', which means the file path would have to be '\MYDIR\MYFILES\MYDIR\MYFILES\DIR.TXT'
Mark
>The name dirtxt is already used for another object. Please choose a different name.
>
>I want to know why I get this error.
>
>Here is my code:
>* I am doing a DIR TO command and making the result into a .DBF file.
>* Thus, taking a list of files in a directory and putting them in a table.
>CD \MYDIR\MYFILES
>DIR TO \MYDIR\MYFILES\DIR.TXT
>
>IF FILE('\MYDIR\MYFILES\DIRTXT.DBF')
> REMOVE TABLE dirtxt DELETE
>ENDIF
>
>CREATE TABLE dirtxt (textline c(80)) && THIS IS WHERE I GET THE ERROR!
>...
>...
>...
>* Then I take the table and select it and read it and process the filenames in the DIRTXT table that I create above.
>
>I don't use the name for another object as far as I can tell. Any ideas? THANKS!
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.