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     [CLOSED] Null/MISSING values getting padded with a space
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Null/MISSING values getting padded with a space
 Login/Join
 
Silver Member
posted
Hi All,

I have a report that is retrieving records from on Oracle database. The report is driven by a dropdown that is populated with data from the same oracle database. Some of the records have null values. When the null values are getting retrieved it appears they are getting padded with a space. So what should be null or '' is now ' '. Since I am using that value to query the database, I am getting no records returned because no records have a value of ' '.

Is there a way to get the padding to stop?

I am using WF 7.6.11 and Oracle 11g.

Thanks,
Cody

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6.8
Linux
HTML,AHTML,PDF
 
Posts: 37 | Registered: June 12, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Have a look at this about MISSING :
How to manage MISSING


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2192 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Null/MISSING values getting padded with a space

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