I have this code:

   SELECT DISTINCT a_arcust.custno, company, city, state, exchange,  
                   SPACE(80) AS list ;
      FROM a_arcust ;                 
      INTO CURSOR c_temp ;
      WHERE EMPTY(lc_cust) OR (a_arcust.custno = ALLT(lc_cust))  ;
      ORDER BY company

   SELECT c_temp

   USE DBF() ALIAS testcur AGAIN

I get an error on the last line saying the file doesn't exist. So I put a SUSPEND right before it. This is what I get from the debugger:

ALIAS() = "c_temp"
DBF() = "C:\windows\temp\14266384.tmp"
FILE(DBF()) = .F.

Sure enough, that temp file doesn't exist anywhere on my hard drive. Why not? I'm not closing the cursor. I know I've used this trick before to make cursors writable and I never had a problem. I tried adding NOFILTER but that didn't make a difference.

I'm completely baffled. Anyone have a clue?

Thanks,

Michelle