Focal Point
[SOLVED] DUPLICATE DASH REPEAT LABEL

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

April 02, 2015, 11:02 AM
GavinL
[SOLVED] DUPLICATE DASH REPEAT LABEL
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 Good One


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