>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



Michelle,

There is no guarantee that a SQL SELECT will create a physical file on disk. If there is enough free memory, it will reside entirely memory.