Focal Point
[SOLVED] diferent group values

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

November 25, 2008, 12:47 PM
expertomad
[SOLVED] diferent group values
I want this
-&VALUE='VAL1,VAL2,VAL3';

TABLE FILE NAME
SUM FIELD
PRINT
FIELD1
WHERE FIELD NE IN (&VALUE);
END
THIS HAVE ERROR
I can to do this thank you

This message has been edited. Last edited by: Kerry,
November 25, 2008, 01:05 PM
Darin Lee
it should be NOT IN instead of NE IN.

Also, when you are getting an error, it is helpful to post the error as well to give us an idea where the problem is.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
November 25, 2008, 01:05 PM
Francis Mariani
...
-SET &VALUE='''VAL1'',''VAL2'',''VAL3''';

...

-TYPE &VALUE
WHERE NOT FIELD IN (&VALUE);
...


It appears you need basic FOCUS training...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 25, 2008, 01:09 PM
Darin Lee
uh, yeah - that's what I meant. Thanks Francis. (Maybe I need some basic FOCUS training too!! Music)


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
November 25, 2008, 01:46 PM
Francis Mariani
Darin, I don't think so!

The other error was the DM code.

Not a good sign.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 25, 2008, 09:03 PM
Waz
Apart from the coding errors, are val1 to valn numeric or text??

If it is a numeric, then you don't need the quotes.

As mentioned in many other posts, do yourself a favour and get a copy of the manuals.


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!

November 26, 2008, 04:11 AM
expertomad
thank you very much for helping me, I've saved a lot of work . you have a good day

Muchas gracias por ayudarme ,me has ahorrado mucho trabjo que tengas un buen dia.