 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Unchecked Check Box Problems
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Unchecked Check Box Problems Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Unchecked Check Box Problems | Login/Join |
| Silver Member |
I am on using App Studio. I have a fex referenced on an html page with multiple parameters. On the html page i have several parameters that return a 1 to my stored procedure if the box is checked. The problem I'm having is when a box is not checked i get a pop up window asking me to enter the remaining parameter values. Once I do that the report works but this is not the desired effect obviously. I tried setting all of my parameters in the dialogue manager to default -DEFAULT &Parameter1 = 0 This did not not solve my issue though. Any help that can be provided is appreciated.This message has been edited. Last edited by: <Kathryn Henning>, WebFOCUS 8 Windows, All Outputs | ||
|
| Master |
SAI_Ryan, There should be an attribute for required on the checkbox. You want to make sure that it is set to no. Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Silver Member |
Eric, Thanks for the suggestion. I first thought was 'I already did that'. After double checking it was not selected so i checked it again. It appears to be not keeping my selection. I select 'No' for selection required and when I go back to the element it is blank. WebFOCUS 8 Windows, All Outputs | |||
|
| Master |
Unfortunately I don't use App Studio, so I can't help with what your experiencing there. I would suggest opening a case with IBI if the tool isn't retaining your selections properly. on another note.... this is yet another reason why I prefer being able to edit the HTML. I can make those changes myself outside of the GUI and prevent it from screwing up my code.... Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Silver Member |
Thanks. I will pursue that. I am new to webfocus and have only used AppStudio. Is there a way to edit the HTML directly or has that functionality been taken away? WebFOCUS 8 Windows, All Outputs | |||
|
| Master |
It has been removed from App Studio. It is available in Dev Studio. In App Studio you can Import HTML. So technically you can still edit the HTML directly. I find the process to be overly cumbersome and extremely buggy. Any time I've tried it, my App studio would crash multiple times in a row. I use Developer Studio and haven't switched to App studio because of this and other irritations that I have with it. Later versions of App Studio (8.0.09 or later), might have some more bugs worked out. I wouldn't know. IBI has explicitly stated that they are working on removing access to the HTML, so at some point I'm sure it will be removed from Developer Studio as well. Either that, or they will just discontinue Dev Studio. I know there are a number of us on Focal Point who are very against this direction that IBI is taking to remove access to the code. Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Silver Member |
So far I would have to agree. I am the only one at my company using appstudio and so far its is 1% building reports and 99% trying to work around this buggy gui that randomly deletes my entire page or undoes all my parameters and a host of other problems I'm having with it. WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
its going to send a 1 or a blank so the default will get killed in any event i do this in my fex: (where the checkbox variable is &sh_ytd0) -DEFAULT &sh_ytd0 = 0; -SET &sh_ytd = IF &sh_ytd0 IS 1 THEN 1 ELSE 0 ; ... note that the DEFAULT does nothing except let me run the fex w/o the launch page. The launch page is going to kill that 0 value, regardless. So the variable i use in my fex is &sh_ytd which i set to 1 or 0 . As an aside, NEVER test the existence of a variable with an IF statement. eg: IF &sh_ytd0.EXIST THEN GOTO someplace. That statement will permanently screw up the .EXIST if it was 0 to begin with. any downstream fexes will be messed up. Instead: -GOTO label.&sh_ytd0.EXIST ; -label.l -TYPE yes &|sh_ytd0.EXIST = &sh_ytd0.EXIST val:&sh_ytd0 -EXIT -label.0 -TYPE nope it doesn't &|sh_ytd0.EXIST = &sh_ytd0.EXIST -EXIT
| |||||
|
| Silver Member |
And as a hack work around, if I create a second check box for the parameter with my 'No' value, I can hide it on the page and it looks the same. Again, not exactly a fix. WebFOCUS 8 Windows, All Outputs | |||
|
| Silver Member |
Susannah, Thanks for the suggestion. That is how I have it now, but the auto prompting facility is still showing up asking me for those variables. From searching I also tried going into the properties of my fex and setting auto prompting of variables off but still no luck. WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
make sure the fex doesn't have 'prompt for paramters' checked in its properties. (go to mre to do that) open a case, i don't know about 8 so its probably squirrely beyond me. are you sure you have -SET &newparm = IF &Parameter1 EQ 1 THEN 1 ELSE 0; test to make sure &Parameter1 exists. -TYPE &|Parameter1.EXIST = &Parameter1.EXIST -EXIT
| |||||
|
| Silver Member |
So your check box parameter is more of a place holder you use to set the actual parameter used in your procedure? Let me try that and see if I have any luck. WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
The check box parameter passes a 1 or a blank i can't use a blank so i have to make sure i set a usable parameter. so i create a new one, based on the incoming one being a 1 or not. just 'or not' but first, be sure of what you have coming in. test for &yourparm.EXIST , see what that value actuall is. 1=the parm exists; 0 means the parm does not exist. that's your first step
| |||||
|
| Silver Member |
i checked all of my parameters hooked up to check boxes and and they all typed out to 1=1. I have already set the prompt for parameters to no in the properties of my fex but the auto prompting debilator keeps coming up. I tried the following for one of my check box variables (where &ExcludeTerm is my check box variable and &ExcludeTerm1 is my new variable that is now being passed to my stored procedure). -DEFAULT &ExcludeTerm = 0 -SET &ExcludeTerm1 = IF &ExcludeTerm EQ 1 THEN 1 ELSE 0; &ExcludeTerm1 works gets passed to my procedure with no prompting, but the auto prompting deblitator still asks for the value of &ExcludeTerm because the check box is not checked. WebFOCUS 8 Windows, All Outputs | |||
|
| Virtuoso |
Maybe all you need is to change your "-DEFAULT" to "-DEFAULTH". My understanding is that -DEFAULT triggers autoprompting for the parameter (when autoprompting is enabled), as well as generation of an input control (in HTML Composer); whereas -DEFAULTH (while functionally equivalent to -DEFAULT at execution time) suppresses the autoprompt (when the reporting server's agent pre-scans the fex). | |||
|
| Expert |
you're absolutely sure that your .htm contains the term 'ExcludeTerm' you've opened it in a text editor and done a search. and in your procedure you type -TYPE &|ExcludeTerm.EXIST = &ExcludeTerm.EXIST you won't get 1=1 if you remember to use the escape pipe | in the TYPE command you would get &ExcludeTerm.EXIST = 1 If you are getting that 1, then type out its size and value -TYPE &|ExcludeTerm.LENGTH= &ExcludeTerm.Length -TYPE &|ExcludeTerm= &ExcludeTerm
| |||||
|
| Silver Member |
I was out of office yesterday afternoon. j.gross, i tried defaulth for my variables also with the same result. susannah- i definitely have a parameter names ExcludeTerm in the GUI. I will try the text editor and confirm and try your other ideas and report back. WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
Did you "BIND" the variable to the text box? Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Platinum Member |
The checkbox control may not bind properly with a DEFAULT variable in FEX. You can use a hidden control instead as follows and bind the variable to it. Use the below code in your javascript tab: function window_onload() { UpdateData(); if(document.getElementById('checkbox10').checked==true) IbComposer_setCurrentSelection('inputhidden1',1); else IbComposer_setCurrentSelection('inputhidden1',0); } Regards, Cyril Joy. WF Production 8008 on Linux. | |||
|
| Virtuoso |
Is your autoprompt set to XMLPROMPT or to XMLRUN? Judging from your descriptions it's the first, the other option is smarter about when to prompt for variables. WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux : | |||
|
| Silver Member |
So i found a solution. Apparently if you leave work frustrated and come back the next day and run it again out of morbid curiousity it will run fine. WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
YES!!
| |||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Unchecked Check Box Problems
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Unchecked Check Box ProblemsCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |