>>If you do a SQL * from a table into a cursor (which would result in the
>>resultant being identical to the FROM table), doing display status shows the
>>(FROM table) being open (which is correct) and the identity of the cursor is
>>identical to the open table except that it shows a different alias and is
>>readonly. If the exected SQL resultant is filtered and the resultant is not
>>identical, the identity of the cursor is different. I was under the
>>impression that a cursor always had an identity of its own!
>
>No, that's pretty much the way it's always been. For performance reasons, if the SELECT statement can return a filtered table instead of creating a new one from scratch, it will.
>
>SELECT *, .T. will give you a non-filtered table in all versions.
>
>SELECT * INTO CURSOR fred NOFILTER will do it in 6 and above, I believe.


Thanks Garrett for the confirmation.