>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer