I don't know exactly what you're trying to do, but here's a couple of points that might help:

- if you're running successive SELECT - SQL statements into cursors, including the NOFILTER clause will force the creation of temporary files to disk.

- some operations on cursors require the cursor's temporary file name. You can get this from the DBF() function e.g.

APPEND FROM (DBF("MyCursorAlias"))

HTH.

>Error 1815 claim that:
>
>We can't make Select statement for any (Select..into cursor) Cursor Object! To do multi-Select and then need (Select...into Table)...
>
>Then, there will be many dummy table if the SQL need more than one select to do...
>
>Besides, how to find a nonexisted dummy filename in a certain directory such as c:\Temp ?
>
>It is strange as VFP5 or previous version allow to use select cursor..
>on select statement again!
>
>#_#; What is your comment!?