Information générale
Catégorie:
Codage, syntaxe et commandes
>>I'm not strong in SELECT SQL but:
>>1. Do you have SET DELETED ON or OFF? It must be OFF.
>>2. DELETED() returns already a logical value. So, no need to test DELETED() = .t.
>>3. Try:
>>
>>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
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