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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     When zero equals blank
Go
New
Search
Notify
Tools
Reply
  
When zero equals blank
 Login/Join
 
Expert
posted
-SET &ECHO=ALL;

-SET &A1 = '0';
-SET &A2 = '';

-SET &A3 = IF &A1 EQ &A2 THEN 'APPLE' ELSE 'ORANGE';

-SET &A4 = IF &A1 EQ '' THEN 'APPLE' ELSE 'ORANGE';

-SET &A5 = IF '&A1.EVAL' EQ &A2 THEN 'APPLE' ELSE 'ORANGE';

-SET &A6 = IF '&A1.EVAL' EQ '' THEN 'APPLE' ELSE 'ORANGE';

-TYPE &A3
-TYPE &A4
-TYPE &A5
-TYPE &A6


I was expecting four ORANGEs. It appears that zero equals blank in Dialog Manager, even if I put the 0 in quotes.


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
Member
posted Hide Post
Please use ASIS and that will solve your problem.

Margaret
 
Posts: 12 | Registered: March 30, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Margaret, thank you very much! I had completely forgotten about ASIS.


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
Virtuoso
posted Hide Post
Hmmmm. Learn something new everyday...had to look that one up.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     When zero equals blank

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