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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums    Search    Search Results
Page 1 2 
Go
Search
Tools
Search Results: (40 matches) New Search Login/Join 

Discussion Topic  RE: Convert Integer to Alpha without leading zeros and without thousands separator (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Unfortunately you cannot trick Excel into thinking a field is text simply by putting quotes around a......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: !mailx with an attachement (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Also, check out the 'mpack' command. You may have to download the source and compile it if it's not ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Limitations... (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Any chance of using Excel Pivot Tables? Just a thought!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Generating CSV files as ouput (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Aparna, on that last sample you submitted, change the statement: ON TABLE HOLD AS myhold FORMAT COM......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Matching (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Unless your 2 files have been saved as FORMAT FOCUS INDEX ID LN FN, then they have to be saved with ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: dynamic query for report painter (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Using the values you provided, the syntax would be something along the lines of: WHERE ( $textField......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Invoking a Unix Shell Script from a WebFOCUS Procedure (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
change the "return 33;" line in your shell script to 'exit 33'...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Large Text Field Handling in new 7.etc versions (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Have your DBA create a "View" that breaks the long text field into 2 or more shorter fields.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Poll - Enhancement to position TITLEs after SUBHEAD Text (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Absolutely "yes". A SUBHEAD should be exactly that, below the HEADING. If it's going to be below t......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Obtain month from a date. (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
In that case, just create a DEFINE with the Month format:......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Is Mailing List Working (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Is this mailing list still active? I haven't received anything in the last few days....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Is Mailing List Working (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Is this mailing list still active? I haven't received anything in the last few days....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: FAQ's: Forum Notification Lists (in Rules, Regulations, and FAQs) by TerryW
Welcome to the forum Maryellen.......
Focal Point > Focal Point Forums > Rules, Regulations, and FAQs

Discussion Topic  NULLS with VARCHAR (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
I am having a problem all of a sudden that seems to be a result of changing a char(30) field in an I......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Vertical Field Placement (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Just a minor syntax error, try this:......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Openning PDFs in Browser window WF534 vs wf436 (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
There is a 2 part interaction on how documents are handled by the browser. The first part is from th......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: FOC file - multiple indexes? (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Yes, a 'FORMAT FOCUS' file can have up to 4 fields indexed this way. At least with the versions of F......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Problem with EXL2K formula (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Actually, the only problem I see here is that you are adding the "* 100" to your percentage calculat......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: LIKE '000%' (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
You are correct Francis. I was confusing regular expressions with SQL syntax. "%" in SQL means zero ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: LIKE '000%' (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
I think the key here is what Kamesh said --- "% - zero or more characters". So what '000%' matches ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders