Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] if ...goto
 Login/Join
 
Platinum Member
posted
HI ALL,
NEED HELP on If ....GOTO.

i have two if statements as:

-IF &XYZ EQ 0 THEN GOTO NOdata ELSE GOTO Data ;
and another similar If stmt is
-IF &ABC EQ 0 THEN GOTO NOdata ELSE GOTO Data ;

i need help on how to tie these above two statements.i mean how to use both &ABC and &XYZ in a single if stmt.

This message has been edited. Last edited by: Kerry,


7.6.7
windows
PDF,EXCEL.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
OR
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi PRARIE,
can i use 'or' like this in IF stmt.


-IF (&ABC or &XYZ) EQ 0 THEN GOTO NOdata ELSE GOTO Data ;

please let me know.


7.6.7
windows
PDF,EXCEL.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
OR is capital O and R.

Why are you not trying
IF
ELSEIF
ELSE


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
This is an OR statement that works similarly for any programming language:

-IF &XYZ EQ 0 OR &ABC EQ 0 GOTO NOdata ELSE GOTO Data;

or
-IF &XYZ EQ 0 GOTO NOdata ELSE 
- IF &ABC EQ 0 GOTO NOdata ELSE GOTO Data;


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
I would always suggest using parentheses, as this forces the order of evaluation.
-IF (&XYZ EQ 0) OR (&ABC EQ 0) GOTO NOdata ELSE GOTO Data;


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6213 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
swati, the IF structure seemed simple enough. If you still have trouble going where you want to go, try -SET &ECHO = ALL to see how DM interpret you IF statement. You will be suprised that...
FOC_NONE <> 'FOC_NONE'
'ABC' <> 'ABC ' or ABC <> 'ABC'
null string <> blanks

Hua


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
thanks all.


7.6.7
windows
PDF,EXCEL.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
Master
posted Hide Post
IF and ELSE IF is safe than OR in some cases

thanks


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.