TABLE FILE NAME SUM FIELD PRINT FIELD1 WHERE FIELD NE IN (&VALUE); END THIS HAVE ERROR I can to do this thank youThis 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!! )
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.