Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Display Percentage as Blank When Value is Null

2 posts in DataWindow Last posting was on 2009-04-13 21:02:43.0Z
JBK Posted on 2009-04-13 18:15:41.0Z
Sender: 6a9.49e37cd1.1804289383@sybase.com
From: JBK
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Display Percentage as Blank When Value is Null
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49e3814d.704.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Apr 2009 11:15:41 -0700
X-Trace: forums-1-dub 1239646541 10.22.241.41 (13 Apr 2009 11:15:41 -0700)
X-Original-Trace: 13 Apr 2009 11:15:41 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89154
Article PK: 418405

Hi All,

Am new to PB and have been tasked to the following:

Based off of input of previous field, the Percentage is
enabled and displayed with a default Format mask of 0.00%,
even if nothing is entered. If that previous field is not
used, then display the percentage as blank.

Customer reported that the display of 0.00% is unacceptable
when the value of the column is stored as null, which is
correct.

The Percentage is defined as Number(5,4) in the Oracle
database.

Any assistance would be greatly appreciated!


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-04-13 21:02:43.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49e3814d.704.1681692777@sybase.com>
Subject: Re: Display Percentage as Blank When Value is Null
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49e3a873$1@forums-1-dub>
Date: 13 Apr 2009 14:02:43 -0700
X-Trace: forums-1-dub 1239656563 10.22.241.152 (13 Apr 2009 14:02:43 -0700)
X-Original-Trace: 13 Apr 2009 14:02:43 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89157
Article PK: 418409

"A number display format can have up to four sections. Only the first is
required.
Positive-format;negative-format;zero-format;null-format"
But you do have to put in negative and zero formats to make a place for the
null format (which would be ' ')
--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<JBK> wrote in message news:49e3814d.704.1681692777@sybase.com...
> Hi All,
>
> Am new to PB and have been tasked to the following:
>
> Based off of input of previous field, the Percentage is
> enabled and displayed with a default Format mask of 0.00%,
> even if nothing is entered. If that previous field is not
> used, then display the percentage as blank.
>
> Customer reported that the display of 0.00% is unacceptable
> when the value of the column is stored as null, which is
> correct.
>
> The Percentage is defined as Number(5,4) in the Oracle
> database.
>
> Any assistance would be greatly appreciated!