Focal Point
[SOLVED] Error with ARGLEN

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

October 18, 2019, 10:27 AM
Tomsweb
[SOLVED] Error with ARGLEN
I am working with a field STATEMENTDISPLAYFORROLLUP, defined as A51V.

When I run this code:
COMPUTE TLEN/I3 = ARGLEN(A51V, STATEMENTDISPLAYFORROLLUP, 'I3');
I get this error:

ERROR AT OR NEAR LINE 15 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: A51V

(FOC009) Request failed validation, not executed.

I thought it was permitted to run ARGLEN against variable length alpha field.

???

Thank you

This message has been edited. Last edited by: Tomsweb,


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
October 18, 2019, 10:37 AM
David Briars
The first parm in ARGLEN is expected to be a number (length) not a format.

I would probably use the LENV function to find the length of a AnV field.
October 18, 2019, 11:00 AM
Tomsweb
David,

Here is my finished product.

   
TABLE FILE PARTNERSTATEMENTXREF
PRINT STATEMENTDISPLAYFORROLLUP
COMPUTE TLEN/I3 = ARGLEN(51, STATEMENTDISPLAYFORROLLUP, 'I3');
-*WHERE RECORDLIMIT EQ 5
ON TABLE HOLD AS TOMMY
END
-RUN

TABLE FILE TOMMY
PRINT STATEMENTDISPLAYFORROLLUP
BY HIGHEST 3 TLEN
END 
-RUN


With these procedures I can create a larger sized field to carry that data forward.

Thank you.

This message has been edited. Last edited by: Tomsweb,


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36