When I have two loops I get an error (FOC1851) duplicate dash repeat label error. Does this mean I can't have two loops or am I doing something wrong?
TABLE FILE CAR
PRINT
CAR.COMP.CAR
ON TABLE HOLD AS CARHOLD FORMAT ALPHA
END
-SET &CARLINES = &LINES;
-RUN
TABLE FILE CAROLAP
SUM
CAROLAP.ORIGIN.COUNTRY
ON TABLE HOLD AS CAROLAPHOLD FORMAT ALPHA
END
-SET &CAROLAPLINES = &LINES;
-RUN
-HTMLFORM BEGIN
<HTML>
<BODY>
-REPEAT HENDNUM FOR &MYDATA FROM 1 TO &CARLINES
-READFILE CARHOLD
!IBI.AMP.CAR;<BR/>
-HENDNUM
-ENDLOOP
-REPEAT HENDNUM FOR &MYDATA2 FROM 1 TO &CAROLAPLINES
-READFILE CAROLAPHOLD
!IBI.AMP.COUNTRY;<BR/>
-HENDNUM
-ENDLOOP
</BODY>
</HTML>
-HTMLFORM END
Results:
<HTML>
<BODY>
JAGUAR <BR/>
JENSEN <BR/>
DATSUN <BR/>
MASERATI <BR/>
TOYOTA <BR/>
AUDI <BR/>
TRIUMPH <BR/>
ALFA ROMEO <BR/>
BMW <BR/>
PEUGEOT <BR/>
<!--
0 NUMBER OF RECORDS IN TABLE= 10 LINES= 10
0 NUMBER OF RECORDS IN TABLE= 5 LINES= 1
(FOC1851) DUPLICATE DASH REPEAT LABEL
-->
EDIT: When I use -? & I see the following results, so I know the data is coming back correctly..
&CARLINES = 10
&CAROLAPLINES = 1
This message has been edited. Last edited by: GavinL,
- FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server
April 02, 2015, 11:45 AM
MartinY
Hi Gavin, You can have multiple loop but not with the same tag's ID as you do
HENDNUM and ENDLOOP exist twice !!!
Need a coffee to have your eyes wider
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
April 02, 2015, 12:42 PM
GavinL
I see.. Thanks..
Answer
-REPEAT HENDNUM FOR &MYDATA FROM 1 TO &CARLINES
-READFILE CARHOLD
!IBI.AMP.CAR;<BR/>
-HENDNUM
-ENDLOOP
-REPEAT HENDNUM2 FOR &MYDATA2 FROM 1 TO &CAROLAPLINES
-READFILE CAROLAPHOLD
!IBI.AMP.COUNTRY;<BR/>
-HENDNUM2
-ENDLOOP
- FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server
April 02, 2015, 01:23 PM
MartinY
You still have twice the ENDLOOP tag which can cause issue on execution if you refer it somewhere...
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
April 02, 2015, 02:17 PM
GavinL
quote:
Originally posted by MartinY: You still have twice the ENDLOOP tag which can cause issue on execution if you refer it somewhere...
When I search help for ENDLOOP I don't get anything.. When I look up REPEAT and doesn't mention the use of ENDLOOP, so is that really required at all?
- FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server
April 02, 2015, 02:53 PM
MartinY
No, it's just a tag that you may refer to if you would like, per example, bypass the loop based on a condition. It can be omit if not useful.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007