>The weirdest thing I've encountered so far was when I SQL Selected a cursor, then indexed it. The Config.fp had "sortwork=c:\scratch\" (it was back in 2.0) and the trouble was that the directory didn't exist. Really don't know how I got Fox to start at all - it should have complained it "cannot create workspace". The Display Status gave me something like "c:\scratch\12345678.tmp" - and reported that the file exists. Though, I couldn't reproduce this anymore, ever.
This is one of the strangest things Fox does - if it has the memory space for a cursor, it assigns a file name but doesn't write the file. So it doesn't KNOW if the sortwork folder exists or not. This behavior is entirely invisible to the user, making it very hard to reproduce. The only way I've found to test it is to look for "File('12345678.tmp'). Internally, you can always 'see' the file with dbf('mycursor').