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: NODATA with MATCH (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
If it has a 0, then change the words "IS MISSING" to "EQ 0" in the DEFINE.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: NODATA with MATCH (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Oops, sorry. I was Focus'ing in (pun intended) on the '$' and not the 'truncate decimal part'. So tr......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: NODATA with MATCH (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
How about adding the '$' via concatenation?......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: NODATA with MATCH (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
OK, since you have a Decimal field, but want to print an Alpha value, then use a DEFINE with an EDIT......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: URGENT ! I need arguments against HTML-DB (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Well I certainly can't give you 10 reasons, but if several of us each gave you 1 or 2, it would add ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Emails not delivered? (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
I was wondering the same thing. I haven't received any Focal Point emails for the past 2 days and wa......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: RANKING (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
That works great ... thanks!!......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: RANKING (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
This looks more like a LIST than a RANK, and does not provide for ties. Unless I am interpreting it ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: RANKING (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Speaking of RANKing, I have a tangential-related question. When you have identical sort field values......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: NULLS with VARCHAR (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Well, I'm back on this varchar() problem again, and have tracked it down to $FOCHOME/focbin/infint a......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: NULLS with VARCHAR (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Well, I'm not using WebFocus, but the old text based version 6.8.5. And the Informix interface looks......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: NULLS with VARCHAR (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Yes, sorry, I should have stated that I re-gen'd the master file definition. But it didn't change. I......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

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: Nodata in Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Also, make sure you're not just re-using a cached copy of the file. When you use a browser, it may s......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: When Output to Excel a alpha value ID is converting to Numeric (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
This is a known bug in Excel that Microsoft refuses to fix. They think all numeric values, even if t......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Focus elements in SQL query (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Ok, give this a try, and remember Focus File Names are very limited in length:......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Using Hold File in a Where statement (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Yes......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Creating and Index for a Hold file (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Just add the word 'INDEX' followed by the fieldname(s) you want to index.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Adding a $ to end of each record? (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
LOL -- "beginning of the last line of each record"?......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Adding a $ to end of each record? (in WebFOCUS/FOCUS Forum on Focal Point ) by TerryW
Well, a simple sed script would be:......
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