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 ENDThis 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