Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Display Multi Select Variable Values in header

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Display Multi Select Variable Values in header
 Login/Join
 
Thomas Foster
Member
posted
I am trying to display the variable contents from a Dynamic Multiple Select Drop-down List Box in a report header.

I am currently getting the error (FOC281) ALPHA ARGUMENTS IN PLACE WHERE NUMERIC ARE CALLED FOR.

The contents look like the following: 'BANK OF AMERICA, N.A.' OR 'BOFA BB SERVE' OR 'WFOUBBSERV'.

The syntax is set to support the WHERE clause data selection, but does not support display in a report header. How do I convert or parse the variable content to then use in the header to show user selcted values?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8.1.05M
Windows 10 Unix Oracle
Excel, PDF, AHTML
 
Posts: 5 | Registered: March 20, 2015Report This Post
j.gross
Virtuoso
posted Hide Post
Please post the statement in your code that the FOC281 msg refers to.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Are you setting the header value in a DEFINE? If so, did you specific a format for the DEFINEd field? If no format is provided, the default is numeric.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Dave
Master
posted Hide Post
Have you tried the "send display value" and use the &..._TEXT parameter to show in the header?


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Thomas Foster
Member
posted Hide Post
Hi All, the code that is currently triggering the error.

-SET &BANK = IF &INIT_PARTY EQ '_FOC_NULL' THEN 'All Banks' ELSE
- &INIT_PARTY.EVAL;

The error again:
(FOC281) ALPHA ARGUMENTS IN PLACE WHERE NUMERIC ARE CALLED FOR

The syntax of the values being passed:

'value1 21 chrs' OR 'value2 13 chrs' OR 'value3 10 chrs'


WebFOCUS 8.1.05M
Windows 10 Unix Oracle
Excel, PDF, AHTML
 
Posts: 5 | Registered: March 20, 2015Report This Post
Thomas Foster
Member
posted Hide Post
Regarding the "send display value" in HTML Composer; when I check the box under properties and settings for Send display value, what do I enter into the box titled Selected Value? What does the syntax look like?


WebFOCUS 8.1.05M
Windows 10 Unix Oracle
Excel, PDF, AHTML
 
Posts: 5 | Registered: March 20, 2015Report This Post
j.gross
Virtuoso
posted Hide Post
Get rid of the ".EVAL"!

.EVAL replaces the referenced &var with its content, so you are essentially attempting to execute

-SET &BANK = 'value1' OR 'value2' OR 'value3';
That offends the Dialog Manager parser, since the OR operator requires numeric operands.



When you drop the .EVAL, you are executing

-SET &BANK = &INIT_PARTY ;
which simply copies the content of one &var to another, without analyzing the content.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Thomas Foster
Member
posted Hide Post
Hi All, this issue is now resolved. The HTML Composer - Properties and settings - Send display value option has worked. I checked this option and then entered the variable name populated by the multi selected drop down list box with the suffix of "_TEXT" and then placed the full variable name "&INITG_PARTY_TEXT" into the header of each report. There are now no errors and the list box values are being passed to the header as plain text separated by a comma. Thank you all for the help and suggestions. Much appreciated!


WebFOCUS 8.1.05M
Windows 10 Unix Oracle
Excel, PDF, AHTML
 
Posts: 5 | Registered: March 20, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Display Multi Select Variable Values in header

Copyright © 1996-2020 Information Builders