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!?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up