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.

Set edit mask property for number field

3 posts in DataWindow Last posting was on 2009-07-28 14:24:58.0Z
shk Posted on 2009-07-28 11:49:11.0Z
From: shk <krishnahari18@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Set edit mask property for number field
Date: Tue, 28 Jul 2009 04:49:11 -0700 (PDT)
Organization: http://groups.google.com
Lines: 16
Message-ID: <e1d34457-9c7e-4860-8df7-3036877393e2@m3g2000pri.googlegroups.com>
NNTP-Posting-Host: 59.96.48.39
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1248781752 6674 127.0.0.1 (28 Jul 2009 11:49:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 28 Jul 2009 11:49:12 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: m3g2000pri.googlegroups.com; posting-host=59.96.48.39; posting-account=3bgqjwoAAADrrBLTF1jYtu1n86yiCXyU
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; FDM),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!m3g2000pri.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89692
Article PK: 418880

Hi,

iam using power builder 8.0 .
i need to set the edit mask property for number field (say amount) and
display in overview

If amount is NULL then dislpay as .00
if amount is 0 then display as 0.00
if amount is .52 then display as 0.52

is it possible to set the editmask property dynamically in datawindow
objcte itself?

please help for the same

thanks in advance


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-07-28 12:13:53.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <e1d34457-9c7e-4860-8df7-3036877393e2@m3g2000pri.googlegroups.com>
Subject: Re: Set edit mask property for number field
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a6eeb81@forums-3-dub.sybase.com>
Date: 28 Jul 2009 05:13:53 -0700
X-Trace: forums-3-dub.sybase.com 1248783233 10.22.241.152 (28 Jul 2009 05:13:53 -0700)
X-Original-Trace: 28 Jul 2009 05:13:53 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89693
Article PK: 418882

That would be the <Columnname>.EditMask.Mask property.
A number display format can have up to four sections. Only the first is
required.

Positive-format;negative-format;zero-format;null-format

I don't have 8 anymore but in 9 there does not appear to be a way to set the
EditMask property with an expression.
--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"shk" <krishnahari18@gmail.com> wrote in message
news:e1d34457-9c7e-4860-8df7-3036877393e2@m3g2000pri.googlegroups.com...
> Hi,
>
> iam using power builder 8.0 .
> i need to set the edit mask property for number field (say amount) and
> display in overview
>
> If amount is NULL then dislpay as .00
> if amount is 0 then display as 0.00
> if amount is .52 then display as 0.52
>
> is it possible to set the editmask property dynamically in datawindow
> objcte itself?
>
> please help for the same
>
> thanks in advance


Scott Morris Posted on 2009-07-28 14:24:58.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <e1d34457-9c7e-4860-8df7-3036877393e2@m3g2000pri.googlegroups.com>
Subject: Re: Set edit mask property for number field
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a6f0a3a$3@forums-3-dub.sybase.com>
Date: 28 Jul 2009 07:24:58 -0700
X-Trace: forums-3-dub.sybase.com 1248791098 10.22.241.152 (28 Jul 2009 07:24:58 -0700)
X-Original-Trace: 28 Jul 2009 07:24:58 -0700, vip152.sybase.com
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89696
Article PK: 418884


"shk" <krishnahari18@gmail.com> wrote in message
news:e1d34457-9c7e-4860-8df7-3036877393e2@m3g2000pri.googlegroups.com...
> Hi,
>
> iam using power builder 8.0 .
> i need to set the edit mask property for number field (say amount) and
> display in overview
>
> If amount is NULL then dislpay as .00
> if amount is 0 then display as 0.00
> if amount is .52 then display as 0.52
>
> is it possible to set the editmask property dynamically in datawindow
> objcte itself?

No.

>
> please help for the same

Except for the particular requirement to display ".00" for null, an edit
mask of "#,##0.00" does exactly what you want (and will display the same
value for both zero and null). Is there a reason for this tiny difference
in display? Could you not display something else that indicated the value
is null (perhaps with color, border, or font differences)? If you are not
using this for data entry, use a display format which should (AFAIK) allow
you to do this. Certainly a computed field could do this as well - again
not for data entry.