 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| How to compare values | Login/Join |
| Silver Member |
Hi all, Need help in how to comapre two values in focus, where the comparison is between a Date field to that of numeric field, below is the code, define file sve mon/m=month_number; //returns the mon values as 06 end table file sve -if mon eq 03 or 06 or 09 or 12 goto wrap1; -goto wrap2 -wrap1 -type qf 4 ends -wrap2 -if mon ne 03 0r 06 or 09 or 12 goto wrap3; -goto wrap4 -wrap3 -type qf 0 ends -wrap4 end If the mon is eq to specified month (3,6,9,12) then should print qf 4 ends else should print qf 0 ends Please help me out. And give me suggestions to solve this problem. Focus Core 7.1.1 & 7.6.4 XP MainFrames | ||
|
| Virtuoso |
Did you try this in WebFocus? Please do make use of the CAR (or one of the other examples databases) and create a FEX with commands that make a bit more sence. The TABLE part of this example holds no real commands The lines you start with - are more or less DM commands, but look a bit like VB too.
| |||||||
|
| Virtuoso |
RB4U, What are you trying to accomplish? TABLE FILE (in CAPITALS please) creates a report. Anything thet starts with a '-' is a Dialog Manager command and is part of pre-processing. Hence it will not have access to FIELD values defined in DEFINE or in a MASTER, but only &variables. So please clarify. Then some help can come your way. Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Expert |
I agree with Frank and Daniel. Make sure its in capitals and give us an example from the CAR file. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
It's obvious that you don't understnad the differences between dialogue manager and straight FOCUS commands. If you did then you wouldn't make the mistake of trying to combine them as you have. Time to RTFM I think!! T
| |||||||||
|
| Master |
What Tony is trying to tell you is that you can't DEFINE a field in a file (FOCUS COMMAND) and use it with -IF (Dialogue Manager command). RTFM=Read the FOCUS Manual! Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Expert |
Thanks for explaining Pat  I should have explained further but you know the old story - been asked several times on the forum before, covered in basic training, blah blah blah ad nauseum. T
| |||||||||
|
| Member |
I'm sorry to see that you have received such negative feedback to your question. You will not find the answer if you just RTFM. That (RTFM) is thrown around entirely to much. The only positive feedback I see is asking you to further state what you are trying to accomplish. On the technical side, they are correct that you are trying to combine WF and Dialog Manager incorrectly (they can be and are used together extensively, just not this way); Are you just attempting to compare the current month to 03, 06, 09 or 12 and then do something? Or, are you trying to strip the month from a DB date, compare it to 03, 06, 09 or 12 and then do something? WebFOCUS 8.0.09 Windows 7 Output: Excel, PDF, HTML | |||
|
| Virtuoso |
Simply put, you WILL find the answer if you just Read the FOCUS manual. It is thrown around extensively because that is step 1 (and can be substituted for by attending training classes.) I know, as do most of the other experienced users, that the manuals are not always clear, the examples aren't always the best, etc. etc. but at least 80%-90% of the time, the solutions to problems that people post are documented in the manuals. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Virtuoso |
rb4u, Are you wanting to format a report with different 'last lines'. For all the back and forth here, I don't see what you want to do in your report. If you want different sutotal lines for example, you might look into subfoot with the WHEN option. Leah | |||
|
| Master |
Guys, if you don't have anything nice to say, then be nice and not say anything at all. I do not thinking anyone is required to answer any posts. On to the post: If you think about it you can think of the WebFOCUS language as 2 languages in one. All command that begin with and dash in (usually in column 1 and variables ( & and && ) are processed then all remainging commands (DEFINES, TABLES, JOINS, etc) are executed they are not aware of each other. just using you simple program you can do this with a define statement and a table request but it might not be what you want DEFINE FILE sve MON/M=MONTH_NUMBER; qf/A1 = IF MON EQ 3 OR MON EQ 6 OR MON EQ 12 THEN '4' ELSE '0'; END TABLE FILE sve PRINT MON qf END If you really what to use the type then you would have to extract the data and hold them format ALPHA. Then use a combination of dialog manager commands (-READ, -TYPE,) and loop thru the records. Hope this helps Scott  | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 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 |