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.

format mask on computed field_beginner

3 posts in DataWindow Last posting was on 2009-04-23 05:59:14.0Z
Matt Posted on 2009-04-22 19:59:19.0Z
Sender: 5675.49ef6e21.1804289383@sybase.com
From: Matt
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: format mask on computed field_beginner
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49ef7717.576a.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Apr 2009 12:59:19 -0700
X-Trace: forums-1-dub 1240430359 10.22.241.41 (22 Apr 2009 12:59:19 -0700)
X-Original-Trace: 22 Apr 2009 12:59:19 -0700, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89189
Article PK: 418440

Greetings,

I need to set up on datawindow computed field format mask
for number digit groups to use comma.

e.g. : I have number 1000.00 in computed field. If I use
format
mask #,##0.00 then I will have 1 000.00 but I need to have
instead of empty space divide thousands the comma ->
1,000.00 . For this I don`t know to set up format mask.

Can anybody help me ?

I know that if I change in "regional and language settings"
in windows in "Digit Grouping symbol" from empty space to
comma then I will have 1,000.00 if I use mask #,##0.00, but
unfortunately I can`t do that so I need to solve it via
format mask on computed field.



Thanx lotlot for answer...


Terry Dykstra [TeamSybase] Posted on 2009-04-23 00:37:45.0Z
Reply-To: "Terry Dykstra [TeamSybase]" <dontreply_tddykstra@forestoil.ca.x>
From: "Terry Dykstra [TeamSybase]" <tddykstra@forestoil.ca>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49ef7717.576a.1681692777@sybase.com>
Subject: Re: format mask on computed field_beginner
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49efb859$1@forums-1-dub>
Date: 22 Apr 2009 17:37:45 -0700
X-Trace: forums-1-dub 1240447065 10.22.241.152 (22 Apr 2009 17:37:45 -0700)
X-Original-Trace: 22 Apr 2009 17:37:45 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89190
Article PK: 418441

What you are saying does not mask sense. If the computed field returns a
number, then using a format mask of #,##0.00 will return 1,000.00, not 1
000.00.
Are you sure you are using a format and not edit mask?

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Matt> wrote in message news:49ef7717.576a.1681692777@sybase.com...
> Greetings,
>
> I need to set up on datawindow computed field format mask
> for number digit groups to use comma.
>
> e.g. : I have number 1000.00 in computed field. If I use
> format
> mask #,##0.00 then I will have 1 000.00 but I need to have
> instead of empty space divide thousands the comma ->
> 1,000.00 . For this I don`t know to set up format mask.
>
> Can anybody help me ?
>
> I know that if I change in "regional and language settings"
> in windows in "Digit Grouping symbol" from empty space to
> comma then I will have 1,000.00 if I use mask #,##0.00, but
> unfortunately I can`t do that so I need to solve it via
> format mask on computed field.
>
>
>
> Thanx lotlot for answer...


Matt Posted on 2009-04-23 05:59:14.0Z
Sender: 6434.49f000a3.846930886@sybase.com
From: Matt
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: format mask on computed field_beginner
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f003b2.6482.1681692777@sybase.com>
References: <49efb859$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Apr 2009 22:59:14 -0700
X-Trace: forums-1-dub 1240466354 10.22.241.41 (22 Apr 2009 22:59:14 -0700)
X-Original-Trace: 22 Apr 2009 22:59:14 -0700, 10.22.241.41
Lines: 54
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89191
Article PK: 418443

If you have in windows "Control Panel" -> "regional and
language setting" in "Digit Grouping symbol" field empty
space then if you put mask #,##0.00 (or # ##0.00) to format
property of a computed field then you get from 1000.00 the 1
000.00 because generally thousand separator is setting on
empty space.
( for 123456789.00 you get 123 456 789.00 )

And now I need to use a format mask which add instead of the
empty space comma even if in "Digit Grouping symbol" is
setting empty space. So finally I need to get 1,000.00 value
from 1000.
( for 123456789.00 you get 123,456,789.00 )

> What you are saying does not mask sense. If the computed
> field returns a number, then using a format mask of #
> ,##0.00 will return 1,000.00, not 1 000.00.
> Are you sure you are using a format and not edit mask?
>
> --
> Terry Dykstra (TeamSybase)
> http://powerbuilder.codeXchange.sybase.com/
> http://casexpress.sybase.com
> product enhancement requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> <Matt> wrote in message
> > news:49ef7717.576a.1681692777@sybase.com... Greetings,
> >
> > I need to set up on datawindow computed field format
> > mask for number digit groups to use comma.
> >
> > e.g. : I have number 1000.00 in computed field. If I use
> > format
> > mask #,##0.00 then I will have 1 000.00 but I need to
> > have instead of empty space divide thousands the comma
> > -> 1,000.00 . For this I don`t know to set up format
> mask. >
> > Can anybody help me ?
> >
> > I know that if I change in "regional and language
> > settings" in windows in "Digit Grouping symbol" from
> > empty space to comma then I will have 1,000.00 if I use
> > mask #,##0.00, but unfortunately I can`t do that so I
> > need to solve it via format mask on computed field.
> >
> >
> >
> > Thanx lotlot for answer...
>
>