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     [CLOSED] HTML: double list control, Selection Required "No"

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] HTML: double list control, Selection Required "No"
 Login/Join
 
JennyY
Member
posted
I have a procedure that lets user to choose which "By" fields they want. I generated one variable for the three optional BY fields. The code looks like this:

TABLE FILE T1
SUM
H1 AS ''
BY LOWEST Field1
BY &RP_FN02B_Sort2.(BY(,,)).Please select sort field(s).
ACROSS YEAR AS ''
END

Then in an HTML file, a double list control is generated for this variable. I set the Selection Required property of the double list control to "No" since I'd like the option to select none. However, when I run it without any selection, I got the error:

THE FIELDNAME IS NOT RECOGNIZED: ACROSS
BYPASSING TO END OF COMMAND

Could anyone help me to find the problem?
Thanks!

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


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 21 | Registered: October 16, 2012Report This Post
JennyY
Member
posted Hide Post
The code looks like this:

TABLE FILE T1
SUM
H1 AS ''
BY LOWEST Field1
BY &RP_FN02B_Sort2.(BY(,,)).Please select sort field(s).
ACROSS YEAR AS ''
END


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 21 | Registered: October 16, 2012Report This Post
BarryS
Gold member
posted Hide Post
Hi Jenny

You are using the new feature in the Report Painter that is created the double list box.

Make sure you select the customselect1 object (the Parent control for the double list box) and there is a property "Default selection" to No. If that does not work then open a case for that issue.

A workaround to the issue is that on load of the double listbox the right box always comes up with the default selected. In the function onInitialUpdate you can try to fire an onclick event for the customselect1_removebutton and that should move the selected value back to the left listbox.

I have not tried the workaround but it should work but if it does not work, open a case with tech support.

Thanks Barry


WebFOCUS 8103, Windows, App Studio
 
Posts: 80 | Location: NYC | Registered: November 13, 2008Report This Post
JennyY
Member
posted Hide Post
Hi Barry, I tried the first option, and it doesn't work. I'll open an case for this.

thanks!
Jenny


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 21 | Registered: October 16, 2012Report This Post
J
Guru
posted Hide Post
Jenny, what is happening is that when you set the field to no selection, the by statement is sorting by nothing.
This is what is being processed at runtime:
BY (nothing)
ACROSS ...

Since there is nothing after BY, webfocus goes down to the next line and sees ACROSS, but across is a key term and not a field thus throwing the error. Here is a trick for optionally having a by field:

   -DEFAULT &RP_FN02B_Sort2 EQ 'Empty';
-SET &BYFIELD = IF &RP_FN02B_Sort2 EQ 'Empty' THEN 'FOC_NONE' ELSE '&RP_FN02B_Sort2_TEXT'

TABLE FILE T1
...
BY &RP_FN02B_Sort2.(BY(,,)).Please select sort field(s). AS '&BY_FIELD'
...
END


There are several parts to this code so I will go line by line.

-DEFAULT &RP_FN02B_Sort2 EQ 'Empty';
-- This will set that variable to empty for no selection.

-SET &BYFIELD = IF &RP_FN02B_Sort2 EQ 'Empty' THEN 'FOC_NONE' ELSE '&RP_FN02B_Sort2_TEXT'
-- This is the heart of the logic.
Basically, if the variable is not selected, set the field title to 'FOC_NONE' ELSE, set the field title to the RP_FN02B_Sort2_TEXT.
RP_FN02B_Sort2_TEXT will return whatever the description value is for that variable. The key is FOC_NONE. Even in the column title, if FOC_NONE
is placed there, then it will wipe out the entire line of code eliminating the by statement all together.

Hope this helps.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
J
Guru
posted Hide Post
Was this ever resolved?


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
vaayu
Guru
posted Hide Post
Hello there.
I'm experiencing this issue in my HTML form using double list control. The first item gets selected and moved to "customselect_selectto" even though I have Default Selection =No for both list boxes. I'm using WF 8.104. Also, I'm not using RIA theme.

Please advise.
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report 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     [CLOSED] HTML: double list control, Selection Required "No"

Copyright © 1996-2020 Information Builders