Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
WHERE clause synatx
 Login/Join
 
Silver Member
posted
HI,
I found this WHERE clause in e fex :
WHERE NOT (FIELDA EQ 'A' OR FIELDDB EQ 'Z');
Is it a valid clause ?
I don't find this in any documentation
Thank's


WebFocus thru Dev Studio version 7.6.11
Dev Studio on Windows Xp, Webfocus Client on UNIX basing on TOMCAT and DB2,
Reporting Server on MVS , USS and on UNIX
 
Posts: 39 | Location: France | Registered: December 10, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
it's valid.

TABLE FILE CAR
SUM SALES
BY COUNTRY
-*WHERE NOT (FIELDA EQ 'A' OR FIELDDB EQ 'Z');
WHERE NOT (COUNTRY EQ 'ENGLAND' OR COUNTRY EQ 'JAPAN');
END


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
WHERE NOT (FIELDA EQ 'A' OR FIELDDB EQ 'Z');

Sometimes negative logic works. In this case if it bothers you, I think

WHERE (FIELDA NE 'A') AND (FIELLB NE 'Z');

Would do the same, correct me if I'm wrong guys and gals.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.