Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not in statement
Message
 
À
03/03/2004 09:55:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00882687
Message ID:
00882804
Vues:
18
This message has been marked as a message which has helped to the initial question of the thread.
Tracy:

I haven't tried this, but what if you do this to the first query--see the new NOT added:
SELECT cn_name, cn_port, cn_printer FROM lcontrol ;
  WHERE !EMPTY(lcontrol.cn_name) .and. NOT (lcontrol.cn_name IN ;
  (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .T.));
  INTO TABLE (hdir+"tTEMPLCONTROL.DBF")
Then applying DeMorgan's Theorem we get:
SELECT cn_name, cn_port, cn_printer FROM lcontrol ;
  WHERE !EMPTY(lcontrol.cn_name) .and. NOT lcontrol.cn_name IN ;
  (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .F.);
  INTO TABLE (hdir+"tTEMPLCONTROL.DBF")
And does this make a difference?
SELECT cn_name, cn_port, cn_printer FROM lcontrol ;
  WHERE !EMPTY(lcontrol.cn_name) .and. lcontrol.cn_name NOT IN ;
  (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .F.);
  INTO TABLE (hdir+"tTEMPLCONTROL.DBF")
It's worth a shot to try it and see what happens, because I'm curious too.

HTH,

--Paul
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform