[SOLVED] Getting error like CONTROL LINE NOT RECOGNIZED IN FOCEXEC
This getting an error while running my report. The error throws like this: CONTROL LINE NOT RECOGNIZED IN FOCEXEC: -REPEAT FCLTY_INFO FOR I FROM 1 TO &MAXFCTY;.
Below are my pieces of code:
quote:
CONTROL LINE NOT RECOGNIZED IN FOCEXEC: -REPEAT FCLTY_INFO FOR I FROM 1 TO &MAXFCTY;
This message has been edited. Last edited by: FP Mod Chuck,
Apps Studio 8.1.0.5 Windows 7
February 19, 2018, 11:15 AM
MartinY
Must be :
-REPEAT FCLTY_INFO FOR &I FROM 1 TO &MAXFCTY;
....your code...
-FCLTY_INFO
Note the end loop tag : -FCLTY_INFO
AND the variable : &I
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
February 19, 2018, 11:22 AM
Wep5622
What's your code?
One thing I notice is that you appear to be using a constant I for a variable.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
You seem to be missing a ; at the end of code line 7. Does &MAXFCTY have a value?
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
February 20, 2018, 04:13 AM
Hemin
Hi Danny,
That was typo error. Semi colon is there. &MAXFCTY having value.
Apps Studio 8.1.0.5 Windows 7
February 20, 2018, 06:18 AM
Danny-SRL
This worked for me:
-SET &FAC_ID = ' ';
-SET &FCTYLIST = ' ';
-SET &FCTYLIST1 = ' ';
DEFINE FILE CAR
FAC_ID/I5=SALES;
FCTYLIST/A30=MODEL;
END
TABLE FILE CAR
PRINT FAC_ID FCTYLIST
ON TABLE HOLD AS FCTYLIST
END
-RUN
-SET &MAXFCTY = &LINES;
-REPEAT FCLTY_INFO FOR &I FROM 1 TO &MAXFCTY;
-READFILE FCTYLIST
-SET &FAC_ID = TRUNCATE(&FAC_ID);
-SET &FCTYLIST = IF &I EQ 1 THEN &FAC_ID ELSE IF &I LT 3000 THEN &FCTYLIST || ','|| &FAC_ID ELSE &FCTYLIST;
-TYPE &FAC_ID : &FCTYLIST
-************
-FCLTY_INFO
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
February 20, 2018, 07:16 AM
Wep5622
This will probably not solve your problem, but it's a waste of cycles to keep looping through the file past that 3000 line limit you seem to impose.
Suggestion:
-SET &MAXFCTY = MIN(&MAXFCTY, 3000);
-REPEAT ...
-SET &FCTYLIST = IF &I EQ 1 THEN &FAC_ID ELSE &FCTYLIST|| ','|| &FAC_ID;
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
February 20, 2018, 07:38 AM
subbu_088
Hemin,
Please try the below code. I just added the sample code using CAR master file. I didn't get any error when I execute it.