General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only