 |
|||||
|
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. | |||||
Page 1 2
Go  | Search | Tools |
|
RE:
[CLOSED] Chaining Question (in WebFOCUS/FOCUS Forum on Focal Point ) by MartinY The "Add 'All option'" put first option to "All" that is equivalent to pass FOC_NONE or _FOC_NULL to your fex. So depending how you code your fex it will ignore the related WHERE clause. But it will ... ignore the WHERE clause in the fex if no selection is made. But it will populate the chained control... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] If statement with an in condition (in WebFOCUS/FOCUS Forum on Focal Point ) by Wep5622I think a small warning about .QUOTEDSTRING is in order here; don't just blindly apply that everywhere.For starters, if you use that in a variable substitution in a FOCUS WHERE-clause (ie. WHERE MYFIELD EQ &MYVARIABLE.QUOTEDSTRING, the variable-value FOC_NONE (meaning "ignore this line") gets... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Wildcard parameter value not returning data. (in WebFOCUS/FOCUS Forum on Focal Point ) by LeahAs TONY A says,Try breaking up the Where statement to two where statements. If you want ALL (FOC_NONE) to work on the STNUMB then you would have just the where with the &STDNUM and then the rest of the selection on the second where to get what you want. Assuming here you want to ignore the STDNUM... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Wildcard parameter value not returning data. (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony Avery first test is comparing against a value of FOC_NONE then WF will ignore it and then encounter the... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] DB2 SQL passthru error (in WebFOCUS/FOCUS Forum on Focal Point ) by Darin LeeActually, it DOESN'T ignore the whole statement - it just seems that way. What it ignores is the entire PHYSICAL line of code on which it appears. If the entire WHERE statement appears on the same line, the whole line is ignored. In the case of a compound statement using AND, this could be a bad... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] Conditional Formatting w several criteria (in WebFOCUS/FOCUS Forum on Focal Point ) by Shingleswant to ignore all the conditions.Anyway... still doing a little unit testing... should be good though... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Table Prompt Slow for SQL (or date problem for WebFocus)) (in WebFOCUS/FOCUS Forum on Focal Point ) by Mighty MaxI use amper variables all of the time in sql pass thru. But I always SET their values before the sql pass thru. I have found some inconsistency using FOC_NONE however. It does not always ignore the line. I usually comment out the line or skip the line. I am not sure if sxschech was trying to SET... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
WebFOCUS 8 Migration Testing? (in WebFOCUS/FOCUS Forum on Focal Point ) by David GlickTom,If you select the "DOCUMENT" object in the Properties sheet, there is a property called "Ignore Filters". It has a dropdown to choose between _FOC_NULL and FOC_NONE. The DOCUMENT object also has a property called "Title of element" and this is what you can change to now show "HtmlPage" as the... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CLOSED] issue w/ DYNAMIC WHERE statement (in WebFOCUS/FOCUS Forum on Focal Point ) by JThat is exactly what I want in some cases, to wipe the entire line. However, in when doing an ignore like that, I would use _FOC_NULL.If I wanted to get rid of a dynamic where statement, I would want to wipe out that line with FOC_NONE (WHERE &where). Caution is needed here, not fear. But each to... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CLOSED] Conditional Footing (in WebFOCUS/FOCUS Forum on Focal Point ) by DavSmithCAR 3) PRINT CAR 4) BY '&HIDE' BY MODEL 5) END The server report engine parser will ignore ALL of... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
too many tables (in WebFOCUS/FOCUS Forum on Focal Point ) by TexasStingrayrequest WHERE SEX EQ &SEX ; if the value of &SEX is FOC_NONE WebFOCUS will ignore the entire line... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] Using the Decode Command (in WebFOCUS/FOCUS Forum on Focal Point ) by Wep5622PE_ZZTTERAP BY ZZTTERI -*I want to ignore this statement if &WINID is not in file PE_ZSASECBP -*WHERE... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point [SOLVED] foc_none OR foc_null (in WebFOCUS/FOCUS Forum on Focal Point ) by Geoff FishI have this code below some of which I found on Focal Point. My dilemma now is that it works but sometimes there is no middle name in which case i need to ignore it. I can enter the first letter followed by % and it will work but occasionally although rarely a donor may have no middle name in which... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[CLOSED] Simple HTML Form Question (in WebFOCUS/FOCUS Forum on Focal Point ) by Darin LeeThat's the way chaining works. The only time anything will happen (modify contents, select values, etc.) in the EmpID# box is when you select a value in the Names box. The "ALL" option is not a value. Under the covers, it is using FOC_NONE which in essence means "ignore this line of code". So if it... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Parm *SELECT ALL on a Dynamic List Selection (in WebFOCUS/FOCUS Forum on Focal Point ) by susannahTWDRVMGR EQ FOC_NONE" , it knows to ignore the filter.See how far you can get with all this so far...... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] Subtract 48 hrs from current Date & Time (in WebFOCUS/FOCUS Forum on Focal Point ) by Wep5622can be FOC_NONE though, it will translate the value in the string 'FOC_NONE' causing WF to not ignore... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
Creating a file to be used in my reporting application drop-downs (in WebFOCUS/FOCUS Forum on Focal Point ) by George Brownignore the line that contains that keyword. I hope this helps more than hinders ... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point
RE:
[SOLVED] searching files on EDASERVE for SQL pass-thru usage (in WebFOCUS/FOCUS Forum on Focal Point ) by dbeaganI did something like this:-DEFAULT &File = '*'; -DEFAULT &Ext = 'fex'; -DEFAULT &Find = 'while'; -DEFAULT &Case = 'ignore'; -SET &Mesg = IF &Find EQ 'FOC_NONE' THEN ' ' ELSE 'Found: ' | -SET &Icase = IF &Case EQ 'ignore' THEN '/i' ELSE ' '; -SET &dlm = CHAR(255); !findstr... Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point | » Refine Search » New Search |
| Powered by Social Strata | Page 1 2 |
 | Please Wait. Your request is being processed... |
Copyright © 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 |