>How can a routine determine if a cursor is truly a (disk based) table or only a temporary cursor. The filename can not necessarily establish that the dbf() in question is a cursor or table.
>
>Thanks
>
>Glenn
I see now that I confused the question.
Depending on your needs, you can also force the cursor NOT to be filtered, just by using the NOFILTER clause in the first SELECT. This is usually recommended if you need the results of a first query in subsequent queries.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)