General information
Category:
Coding, syntax & commands
Thanks Ed for ur reply and congratulation to ur doctorate achievement. I'm using VFP7 BTW. Do u mean if I'm to SQL Select from a cursor, I must make sure the 1st SQL Select has NOFILTER clause? In effect, I can never use Rushmore optimization on the 1st.query? Is this a path I must always aware of in future SQL Select.... BTW u did mentioned filter view, please explain the meaning.
Regards.
>>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
Previous
Next
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