Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement