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] Getting an extra character at the beginning of variable using -READ
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Getting an extra character at the beginning of variable using -READ
 Login/Join
 
Gold member
posted
I'm trying to pass in a value from a table into a variable using -READ for a header

 TABLE FILE METRIC
BY METRIC_NAME
WHERE METRIC_CODE EQ '&METRIC'
ON TABLE HOLD AS HEADER
END
-RUN
-READ HEADER, &HEADER.A50. 


Everything works perfectly, except when I check the value of &HEADER, a hyphen shows up at the beginning. If I expect 'foo', I instead get '-foo'. Why is this happening, and how would I fix this?

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


WebFOCUS 8.2.01M on Windows 10
 
Posts: 54 | Registered: July 30, 2018Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hello,

Can you try this.

TABLE FILE CAR
BY CAR
WHERE CAR EQ 'BMW'
ON TABLE HOLD AS HEADER FORMAT ALPHA
END
-RUN
-READ HEADER &VAR_NAME.A11


-TYPE &VAR_NAME
 
Posts: 110 | Registered: February 02, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Ccollier

Try -READFILE HEADER

The variable name will be &METRIC_NAME


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1808 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
If you use -READFILE, you will need to prime the variable so it doesn't get prompted.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6248 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Does METRIC_NAME is a variable field length such as A50V ?

Try with this
TABLE FILE METRIC
BY METRIC_NAME/A50
WHERE METRIC_CODE EQ '&METRIC'
ON TABLE HOLD AS HEADER
END
-RUN
-READ HEADER, &HEADER.A50. 

But as mentioned already, you should better use READFILE

TABLE FILE METRIC
BY METRIC_NAME/A50
WHERE METRIC_CODE EQ '&METRIC'
ON TABLE HOLD AS HEADER
END
-RUN
-READFILE HEADER
-DEFAULTH &METRIC_NAME = ''


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
 
Posts: 2293 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
As you guy said, using the -READFILE worked properly. Thanks!


WebFOCUS 8.2.01M on Windows 10
 
Posts: 54 | Registered: July 30, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Beware of changing the format in the TABLE request. See:
  
TABLE FILE CAR
BY COUNTRY/A20
ON TABLE HOLD
END
?FF HOLD
-RUN
-READFILE HOLD
-TYPE &COUNTRY &COUNTRY.LENGTH

-* Output:
  
 0 NUMBER OF RECORDS IN TABLE=        5  LINES=      5
 FILENAME=  HOLD
 COUNTRY       E01           A20
 COUNTRY       E02           A10
 ENGLAND    10


However:
  
TABLE FILE CAR
BY COUNTRY/A20
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD
END
?FF HOLD
-RUN
-READFILE HOLD
-TYPE &COUNTRY &COUNTRY.LENGTH
-* output
 0 NUMBER OF RECORDS IN TABLE=        5  LINES=      5
 FILENAME=  HOLD
 COUNTRY       E01           A20
 ENGLAND              20



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1949 | Location: Tel Aviv, Israel | Registered: March 23, 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] Getting an extra character at the beginning of variable using -READ

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