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] Check on pulling table value into variable
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Check on pulling table value into variable
 Login/Join
 
Silver Member
posted
Good Afternoon,

Thought I understood this, apparently not.

-DEFAULTH &Test=0;
-DEFAULTH &&Test=0;
TABLE FILE HOLD_TMP
BY
HOLD_TMP.TestID AS 'Test'
WHERE ( ROWCNT EQ 1 );
ON TABLE HOLD AS HOLD_TMP_A FORMAT ALPHA
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SET HTMLEMBEDIMG OFF
ON TABLE SET HTMLCSS OFF
END
-RUN
-READ HOLD_TMP_A
-RUN
-CLOSE HOLD_TMP_A
-SET &&Test=&Test;
-TYPE &&Test

HOLD_TMP is a table with structure (TestID guid, ROWCNT int). In this example I want to pull the first row and put the value in a variable, (this will actually be placed in a loop to iterate over the whole table, performing quite a bit of business logic on each value), but instead of a guid I am getting 0. I have this same idea working in another procedure hence the "Thought I understood this, apparently not." Is there something obvious I'm missing or what things should I start looking at?

Thanks!

This message has been edited. Last edited by: FP Mod Chuck,


Windows 8203 All output formats
 
Posts: 47 | Registered: November 30, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try this
TABLE FILE HOLD_TMP
BY TESTID
WHERE ROWCNT EQ 1;
ON TABLE HOLD AS HOLD_TMP_A
END
-RUN
-READFILE HOLD_TMP_A
-RUN
-DEFAULTH &TESTID = 0
-DEFAULTH &&TEST = 0
-SET &&TEST=&TESTID;
-TYPE TEST=&&TEST

When you use -READ you must specify the field name.format. (-READ HOLD_TMP_A &TESTID.I5.) which is not the case using -READFILE and much more simple to use.


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2233 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
Worked, thanks!


Windows 8203 All output formats
 
Posts: 47 | Registered: November 30, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Check on pulling table value into variable

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