Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error with ARGLEN
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Error with ARGLEN
 Login/Join
 
Master
posted
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
 
Posts: 553 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
Master
posted Hide Post
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.
 
Posts: 780 | Registered: April 23, 2003Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 553 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error with ARGLEN

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.