Searched for error FOC32565 on FocalPoint - nada.

This code triggers the error:

TABLE FILE DDT001
SUM
COMPUTE AMT/P17.2BC =
IF (EDIT(DDROW,'999$') NE 'FTE') THEN BALNIE / 1000 ELSE BALNIE;
BY SUMDIV
BY SUMDIV_NAME
ACROSS YRMTH
BY ROWPREFIX
BY ROWPREFIX3
BY DDROW
FOR DDROW
NIE01A                                           LABEL NIE01A       OVER
NIE01B                                           LABEL NIE01B       OVER
RECAP NIE01HIGH/P17.2BC = NIE01A + NIE01B;       LABEL NIE01HIGH
WHERE DDROW NE 'N/A';
WHERE (YRMTH GE '201011' AND YRMTH LE '201102');
ON TABLE HOLD AS H001
END

This code has no error:

TABLE FILE DDT001
SUM
COMPUTE AMT/P17.2BC =
IF (EDIT(DDROW,'999$') NE 'FTE') THEN BALNIE / 1000 ELSE BALNIE;
BY SUMDIV
BY SUMDIV_NAME
ACROSS YRMTH
BY ROWPREFIX
BY ROWPREFIX3
BY DDROW
FOR DDROW
NIE01A                                           LABEL NIE01A       OVER
NIE01B                                           LABEL NIE01B       
WHERE DDROW NE 'N/A';
WHERE (YRMTH GE '201011' AND YRMTH LE '201102');
ON TABLE HOLD AS H001
END

It seems to have something to do with label names or row values that are different in size, i.e. NIE01A and NIE01B are the same length, but NIE01HIGH is longer.

Any ideas?

Thanks,

This message has been edited. Last edited by: Francis Mariani,

Seems like including the format in the RECAP (P17.2BC) causes the error. But I need the format, otherwise the RECAP value is zero.

I seem to have it working using the CAR file.

SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
TABLE FILE CAR
SUM SALES
BY SEATS
FOR COUNTRY 
JAPAN   LABEL JAPAN   OVER
ENGLAND LABEL ENGLAND OVER
RECAP JPEN/I5 = JAPAN + ENGLAND; OVER
ITALY

ON TABLE HOLD AS H001
END
-RUN

?FF H001
-RUN

TABLE FILE H001
PRINT 
SALES
BY SEATS
BY E02
END
-RUN

As shown in this example, I have an intermediary HOLD file and, when created using FML, you have to be careful.

quote:

FOC32565

FML it is documented (I cannot find the specific page to look at).

This is specifically because you are doing a HOLD.

Reformat on RECAP is not allowed.

The formats for NIE01HIGH , NIE01A and NIE01B must all be the same.

Do a DEFINE on NIE01A and NIE01B

It's strange behaviour. It's a combination of RECAP with format AND with the COMPUTE statement - even though the formats are the same. If I remove the COMPUTE, it works. I'll move the COMPUTE out of this piece of code.

I will open a case for this.

Thought about becoming an IBI tester ?

You certainly find the obscure ones.

Francis,

did you open a case for this? If I open another case I'll scream. I have code that works fine in 7.6.1 but not in 7.7.03
I have a define field that has the same format and never changes but I'm getting that error.