>Hi all,
>
>I hope someone can explain the phenomenon I'm seeing at below in command window :
>
>Case 1:
>=======
>SELECT * FROM demas INTO CURSOR ABC
>SELECT cnoee FROM ABC INTO CURSOR BCD
>Error Message : ABC must be created with Select ... INTO TABLE
>
My guess is that you're using an older version of VFP, and it's creating a filtered view rather than a real cursor. If current, add the NOFILTER clause to the first query; if early version, add a "WHERE .t." so that it is not fully Rushmore optimizable as a single query from a table, so you get the filter.
>Case 2:
>=======
>SELECT * FROM demas INTO CURSOR ABC NOFILTER
>SELECT cnoee FROM ABC INTO CURSOR BCD
>No error message.
>
Yep - this is the exact behavior described above.
>Case 3:
>=======
>SELECT dxand.*,cname FROM dxand,demas WHERE dxand.cnoee=demas.cnoee INTO CURSOR ABC
>SELECT cnoee,cname FROM ABC INTO CURSOR BCD
>No error message.
>
Two tables, so the query can't be satisfied from a filtered view of a single table