Hi:
I have the following problem. I have an SQL statement something like this:

cSelectStat = "select "+lcfields +;
" FROM a "+;
" left Join b On b.fieldpk = a.fieldfk "+;
" left Join c On c.fieldpk = b.fieldpk "+;
" left Join d On d.fieldpk = c.fieldpk "+;
" left Join e On e.fieldpk = d.fieldpk "+;
" left Join f On f.fieldid = e.fieldpk "+;

&cSelectStat into cursor curtemp readwrite

select curtemp

And it returns me an error like this after executing the last statement: File ‘curtemp.dbf’ does not exist.
Is this a setting in FoxPro that I’m missing or something? Are there any instances it will fail to create a cursor? From what I understand that even the records set return no records that cursor still exist.

Please advise.

Thanks,
Jan