>>When I type !NDIR /SORT [some sortspec] in command window I can get response on FoxPro desktop ( as with most any DOS/NetWare commands) I am trying...
>I have the code at work - give me a hint about which parts you'd like to know about.
I'm sending to dbf also, just interested in what other info/experience others have had. I'm planning on having fields for filename, ext, last access date, pdir [foreign key for Directories.Pdir PKey] One table will have parent dirs id [pdirid] pkey [id] and name [dirname] id will be foriegn key in filename table as apposed to having full path stored. I feel breaking it up into smaller pieces [DIR,SUBDIR,FILENAME,EXT,DATE..] will make for easier management and enhancements down the road. I also understand this may be overkill. Next step I plan is to use this table to generate a listfile for PKZip to move files off server into zipfile on local drive that I can dump onto zipdrive for archiving. One caveat I'm current dealing with a sure fire way to take line I've pulled out of file created with !NIR /sortspec >Files.txt and test for valid filename.
Currently I'm testing the 1st byte of that line for alpha/numeric if so grab 1st 12 bytes (8.3) using FILE() to test for valid file if so INSERT INTO dbf. Any code, comments, suggestions or pitfalls greatly appreciated.