Focal Point
[SOLVED] where not in file

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

August 11, 2009, 10:06 AM
trishH
[SOLVED] where not in file
OK it should be:
WHERE NOT USERID IN FILE EUSERS

hello
the following line in my program works:

WHERE USERID IN FILE EUSERS

but this one (which i want to use) does not:

WHERE USERID NOT IN FILE EUSERS

thanks for any suggestions.
trish


webfocus windows 7.6.4

This message has been edited. Last edited by: trishH,


webfocus 7.703, windows, pdf,excel,html
August 11, 2009, 05:40 PM
Waz
Move the NOT to before the Field name.

WHERE NOT USERID IN FILE EUSERS



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!