Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's wrong with this SELECT?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00025329
Message ID:
00025363
Vues:
29
>>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
Fil
Voir

Click here to load this message in the networking platform