IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Default Value not getting overwritten
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Gold member
Posted
Hi,

I am expecting a variable &EMPLID from my HTML page (EMPLID is a textbox). In my fex which is called by the HTML, I am defaulting EMPLID as

-DEFAULTS &EMPLID = '123' ;

and then writing

-SET &EMPLID = IF '&EMPLID' EQ '' OR ' ' OR 'N_A' THEN NULL ELSE &EMPLID;

If I dont enter anything in the EMPLID textbox I pass a blank in EMPLID. But even after comparison with '' or ' ' I dont get the value NULL, instead I still get the default value i.e. 123. Why is it behaving strangely.

Also if I dont give &EMPLID in single quotes on Right Hand Side it given an error comparison between Computational and Alpha values not allowed. Why?

Thanks
CD
 
Posts: 78 | Registered: December 11, 2005Reply With QuoteEdit or Delete MessageReport This Post
Master
Posted Hide Post
CD

Use:
-SET &EMPLID = IF &EMPLID EQ '' 
-              OR &EMPLID EQ ' ' 
-              OR &EMPLID EQ 'N_A' THEN NULL ELSE &EMPLID;

DM 'lazy' OR logic is not valid.


Alan.
WF 7.6.5, PMF 5.1, MRE,RA,RG, etc... Win2003(8xQuad)/IIS/Tomcat with SSL and AD security.
 
Posts: 848 | Location: Portugal | Registered: February 07, 2007Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
Posted Hide Post
You also might try a ? & at the beginning to see if what you think is being passed really is being passed.


Regards,

Darin



WF Server: 7.1.6 on Z/OS and Linux, ReportCaster, Self-Service, MRE, Java
Data: DB2, DB2/UDB, Adabas, SQL Server Output: HTML,PDF,Excel2K
WF Client: Linux w/WebSphere, Servlet, CGI
 
Posts: 1323 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Default Value not getting overwritten

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