Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not in statement
Message
 
 
To
03/03/2004 09:55:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00882687
Message ID:
00882804
Views:
17
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform