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 3 4 ... 61
Go
Search
Tools
Search Results: (1213 matches) New Search Login/Join 

Discussion Topic  RE: [CLOSED] getting FOC1346 and FOC1130 error in webfocus (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Since the error message points to the first record, is it possible the first row in the data file is......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] FOC1346 & FOC1130 Error Messages (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You're getting an error on the SET ASNAMES command: (FOC822) VALID VALUES ARE ASNAMES=OFF ON FOCUS ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] FOC1346 & FOC1130 Error Messages (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I'm not sure what the limit is on packed (P) fields these days. It used to be 31, so P33.3 may be a......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] FOC1346 & FOC1130 Error Messages (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
See if removing the AS names makes a difference. If you're not using the SET ASNAMES = ON setting, ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] FOC1346 & FOC1130 Error Messages (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You might also want to use the WHENCE command to see if you have another HOLDRPT master lurking some......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] DEFINE field comparing dates, IF...ELSE... and Loops (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Ah yes....XDATE_0 would need to be previously defined despite the fact that it will never be used. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] DEFINE field comparing dates, IF...ELSE... and Loops (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Maybe use a -REPEAT loop? This sample code should carry the latest date forward to the last xdate f......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] BOT Tables - What does BOT Signify? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Report ro......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] EXL2K vs XLSX - Special characters (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Take a look at this thread: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Day of week from SQL Server Date field (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
DOWK expects the date in legacy I8YYMD format (like &YYMD). Your LOADDATE will be defined as a Smar......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]How to write NODATA to display empty report w/o using Master file/HTML FORM (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Would the ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Finding out a total for a ROW for only negative values. (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Maybe something like this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]Maximum Filter (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Adding this SET statement to your query will increase the number of values permitted in an IN FILE c......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Resolved in Gen 913] extra tables in translated SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Maybe because the translator isn't certain where this condition will be resolved? ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]APP MAP across a Windows Domain Boundary (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Maybe something like this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]APP MAP across a Windows Domain Boundary (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If you can't get APP MAP to work, have you considered using ! COPY to copy the files to the destinat......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] SQL.DTDIFF (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I believe function DB_EXPR has replaced SQL. as the preferred method to pass SQL functions directly ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] RECOMPUTE Column total of AVG % (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I believe you will need to explicitly perform the calculation if you want it RECOMPUTEd for the TOTA......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]Get the datetime in millisecond since 1970/01/01 (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Since 1970/01/01 is the base date for ReportCaster and ReportCaster uses GMT times for scheduling an......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Best Practices for Displaying Long Reports (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Here is one approach. If you are using something like BY HIGHEST 20 in your report program, you may......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3 4 ... 61 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders