Use the NOFILTER clause in your SELECT statement.
Mark
>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...
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.