>Hi,
>
>Hope someone can help me with this. We have an application
>that creates cursors in the MAIN for use in the whole app.
>Problem is some of the cursors seem to be copies of the
>actual table (has all fields and indexes) and exist as actual
>tables (CSAMPLE.DBF) while others exist as cursors (stored in
>the temp i.e. C:\TEMP\01021598.TMP) when we do display status.
>
>The syntax we use is the same for all using sql select. For
>example:
>
>select Field1, Field2 from Sample order by Field1 ;
>into cursor cSample
>
>select Field1, Field2 from Sample2 order by Field1 ;
>into cursor cSample2
>
>etc...
>
>TIA
>
Hi Arriyel,

If I recall correctly, the location of the tmp files generated by an SQL statement is determined by the setting in the CONFIG file. I think it's SORTWORK.