Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>SELECT ObjectID ;
>>>>FROM Test t1;
>>>>WHERE (not DELETED()) and (t1.ParentID IN ;
>>>>(SELECT ObjectID FROM Test t2 WHERE DELETED()));
>>>>INTO CURSOR ToDel
>>>>
>>>>Vlad
>>>
>>>SET DELETED is OFF
>>>
>>>I add the "= .T." to keep the SELECT more readable.
>>>
>>>I tryed your's but nothing is returned!
>>>
>>>What's wrong?
>>
>>Try to see if the inner SELECT returns something. It does not depend on the outer SELECT.
>>
>>Do you have deleted records in Test? :)
>>
>>Vlad
>
>Of course, one record is deleted.
>
>I try each parts of this select in "stand alone mode" and each of them work fine. But "team work" does not do the job...
>
>I think about some little pest with thousand of legs who play with my computer... :-(
What if you put the INTO CURSOR before WHERE?
Vlad
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