Focal Point
[CLOSED] USE file

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

June 04, 2013, 10:55 AM
Leanne Wood
[CLOSED] USE file
Good morning-

I'm using the following file to create mailing labels for students who have left for the summer. The file is supposed to produce 30 labels for each student, but it's only producing one per student. We have recently upgraded from 7.6.5 to 7.7.03, so I'm wondering of the code has changed since 7.6.5. Any help would be most appreciated. Here is an example of the USE file:

-* useit.fex -- USE file many times
USE CLEAR
-SET &COUNTER = 1;
USE ADD
-LOOP
-IF &COUNTER GT 30 GOTO FINISH;
MAILFWD2.FOC
-* was this in WF 523: mailfwd2.foc FOCUS F
-SET COUNTER = &COUNTER + 1;
-GOTO LOOP
-FINISH
END
END

This message has been edited. Last edited by: Leanne Wood,


WebFOCUS 8.2.02M, App Studio 8.2.02M
Windows 2012 Server, Excel
June 04, 2013, 01:01 PM
Francis Mariani
I am very surprised this worked in v7.6.5.

In v7.7.03 you get an error: (FOC012) THE WORD 'FILE' OR THE FILENAME APPEARS TWICE

because the same focus db is specified more than once.

This is what I would do:

TABLE FILE CAR
PRINT COUNTRY
BY COUNTRY NOPRINT

-REPEAT ENDREP1 30 TIMES

MORE
FILE CAR

-ENDREP1 
END
-RUN



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
June 14, 2013, 08:56 AM
Leanne Wood
Francis- thank you very much for your response. I will try that.


WebFOCUS 8.2.02M, App Studio 8.2.02M
Windows 2012 Server, Excel