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.

Problem using Edit Mask Control

4 posts in Objects Last posting was on 2002-06-24 22:03:37.0Z
Dewang Bhansali Posted on 2002-06-21 19:59:57.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Dewang Bhansali" <dewangb@hotmail.com>
Subject: Problem using Edit Mask Control
Date: Sat, 22 Jun 2002 01:29:57 +0530
Lines: 27
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 203.197.55.137
Message-ID: <364_WaK8H4VGCHA.247@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1163
Article PK: 713724

Hello Everybody,

I have got a problem, I have the requirement in which I am using edit mask
control and using numeric! mask type. I am defining the mask as

##,##,##0.00

but when I run the program it takes it as

#,###,##0.00

Can anyone tell me how to achieve this. I want the same in datawindow
editmask style also.

Same thing happens if I use string(number,format) function.

Any help will be highly appreciated.

Regards,

Dewang


Jim Ory Posted on 2002-06-21 20:24:35.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Jim Ory" <jimory@charter.net>
Subject: Re: Problem using Edit Mask Control
Date: Fri, 21 Jun 2002 15:24:35 -0500
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: mv1-24.217.147.154.charter-stl.com 24.217.147.154
Message-ID: <364_Hs0pkNWGCHA.290@forums.sybase.com>
References: <364_WaK8H4VGCHA.247@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1162
Article PK: 713726

Edit mask and formats seem to be converted by the setting in the windows
regional settings. Powerbuilder documentation says use a comma for group
symbol, a period for decimal symbol and a dollar sign for currency symbol
for all countries and PB will correct the format or mask according to the
windows regional setting. This includes Digit grouping. I don't think there
is a way to override this.

If you would like to test this you could go to windows regional setting and
change the digit grouping from 123,456,789 to 12,34,56,789.

"Dewang Bhansali" <dewangb@hotmail.com> wrote in message
news:WaK8H4VGCHA.247@forums.sybase.com...
>
> Hello Everybody,
>
> I have got a problem, I have the requirement in which I am using edit mask
> control and using numeric! mask type. I am defining the mask as
>
> ##,##,##0.00
>
> but when I run the program it takes it as
>
> #,###,##0.00
>
> Can anyone tell me how to achieve this. I want the same in datawindow
> editmask style also.
>
> Same thing happens if I use string(number,format) function.
>
> Any help will be highly appreciated.
>
> Regards,
>
> Dewang
>
>
>
>
>


Dewang Bhansali Posted on 2002-06-22 05:04:58.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Dewang Bhansali" <dewangb@hotmail.com>
Subject: Re: Problem using Edit Mask Control
Date: Sat, 22 Jun 2002 10:34:58 +0530
Lines: 68
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 203.199.74.31
Message-ID: <364_IlqmnoaGCHA.247@forums.sybase.com>
References: <364_WaK8H4VGCHA.247@forums.sybase.com> <364_Hs0pkNWGCHA.290@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1161
Article PK: 713725

Jim,

Thanks for your prompt response, I also thought it would have to do
something with regional settings. But you gave the exact guideline for the
problem. I cannot change in the refional setting the grouping as

12,34,56,789

because it allows either grouping as

123,456,789

or

1,23,45,67,89

I just do not know how am i going to solve this problem.

Then also thanks for the guideline.

Regards,

Dewang

Jim Ory wrote in message ...
> Edit mask and formats seem to be converted by the setting in the windows
>regional settings. Powerbuilder documentation says use a comma for group
>symbol, a period for decimal symbol and a dollar sign for currency symbol
>for all countries and PB will correct the format or mask according to the
>windows regional setting. This includes Digit grouping. I don't think there
>is a way to override this.
>
>If you would like to test this you could go to windows regional setting and
>change the digit grouping from 123,456,789 to 12,34,56,789.
>
>"Dewang Bhansali" <dewangb@hotmail.com> wrote in message
>news:WaK8H4VGCHA.247@forums.sybase.com...
>>
>> Hello Everybody,
>>
>> I have got a problem, I have the requirement in which I am using edit
mask
>> control and using numeric! mask type. I am defining the mask as
>>
>> ##,##,##0.00
>>
>> but when I run the program it takes it as
>>
>> #,###,##0.00
>>
>> Can anyone tell me how to achieve this. I want the same in datawindow
>> editmask style also.
>>
>> Same thing happens if I use string(number,format) function.
>>
>> Any help will be highly appreciated.
>>
>> Regards,
>>
>> Dewang
>>
>>
>>
>>
>>
>
>


Martin M Eichelman, Jr <no-reply Posted on 2002-06-24 22:03:37.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: Martin M Eichelman, Jr <no-reply@strategic-alt.com>
Subject: Re: Problem using Edit Mask Control
Date: Mon, 24 Jun 2002 15:03:37 -0700
Organization: Strategic Alternatives Inc
X-Newsreader: MicroPlanet Gravity v2.60
Lines: 57
NNTP-Posting-Host: 12.22.218.52
Message-ID: <364_sn1cpv8GCHA.290@forums.sybase.com>
References: <364_WaK8H4VGCHA.247@forums.sybase.com> <364_Hs0pkNWGCHA.290@forums.sybase.com> <364_IlqmnoaGCHA.247@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1157
Article PK: 713716

Not a very elegant solution, but as a potential last resort..

Write a function that converts the number to string (no specific
format), parse it to get just the numeric values, and reassemble in the
format you need.

The display column will need to be string to display the value as you
have reassembled it.

Like I said, not an elegant solution, but at least there's hope.

:: m a r t y

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Martin M Eichelman, Jr
Strategic Alternatives Inc
http://www.strategic-alt.com


In article <IlqmnoaGCHA.247@forums.sybase.com>, Dewang Bhansali
<dewangb@hotmail.com> says...

> Jim,
>
> Thanks for your prompt response, I also thought it would have to do
> something with regional settings. But you gave the exact guideline for the
> problem. I cannot change in the refional setting the grouping as
>
> 12,34,56,789
>
> because it allows either grouping as
>
> 123,456,789
>
> or
>
> 1,23,45,67,89
>
> I just do not know how am i going to solve this problem.
>
> Then also thanks for the guideline.
>
> Regards,
>
> Dewang
> Jim Ory wrote in message ...
> > Edit mask and formats seem to be converted by the setting in the windows
> >regional settings. Powerbuilder documentation says use a comma for group
> >symbol, a period for decimal symbol and a dollar sign for currency symbol
> >for all countries and PB will correct the format or mask according to the
> >windows regional setting. This includes Digit grouping. I don't think there
> >is a way to override this.
> >
> >If you would like to test this you could go to windows regional setting and
> >change the digit grouping from 123,456,789 to 12,34,56,789.
> >
> >"Dewang Bhansali" <dewangb@hotmail.com> wrote in message
> >news:WaK8H4VGCHA.247@forums.sybase.com...
> >>
> >> Hello Everybody,
> >>
> >> I have got a problem, I have the requirement in which I am using edit
> mask
> >> control and using numeric! mask type. I am defining the mask as
> >>
> >> ##,##,##0.00
> >>
> >> but when I run the program it takes it as
> >>
> >> #,###,##0.00
> >>
> >> Can anyone tell me how to achieve this. I want the same in datawindow