Focal Point
WHERE clause synatx

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7001061262

December 18, 2007, 03:57 AM
philippe@Nantes
WHERE clause synatx
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
December 18, 2007, 09:24 AM
Spence
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.
December 18, 2007, 09:27 AM
Leah
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