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.

$#,##0.00;[RED]($#,##0.00) what this format means

6 posts in DataWindow Last posting was on 2009-06-17 15:36:56.0Z
Siva Posted on 2009-06-16 14:41:38.0Z
Sender: 409b.4a3745a9.1804289383@sybase.com
From: Siva
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: $#,##0.00;[RED]($#,##0.00) what this format means
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a37af22.4f6f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Jun 2009 07:41:38 -0700
X-Trace: forums-1-dub 1245163298 10.22.241.41 (16 Jun 2009 07:41:38 -0700)
X-Original-Trace: 16 Jun 2009 07:41:38 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89489
Article PK: 418680

Hi All

i am new to powerbuilder

i have datawindow column and it have format -
$#,##0.00;[RED]($#,##0.00)

Please tell me what it means What is ;[RED]

and what is ($#,##0.00) same things in 2 different formate

can any one explain me


Chris Pollach Posted on 2009-06-16 14:57:11.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a37af22.4f6f.1681692777@sybase.com>
Subject: Re: $#,##0.00;[RED]($#,##0.00) what this format means
Lines: 36
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: <4a37b2c7$1@forums-1-dub>
Date: 16 Jun 2009 07:57:11 -0700
X-Trace: forums-1-dub 1245164231 10.22.241.152 (16 Jun 2009 07:57:11 -0700)
X-Original-Trace: 16 Jun 2009 07:57:11 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89490
Article PK: 418681

Hi Siva;

PB uses standard MS-Excel display and edit mask patterns to control
numeric data. In your case, the pattern before the ";" is positive and the
part after the ";" is negative. The +ve pattern indicates a money value with
zero suppression until the one dollar range. The -ve pattern uses a red
colouring with the same zero suppression.

For more information on these display/edit masks .. have a look at the
PB Help file and search for "Display Format Dialog Box". You should find a
link in that help section to the "Working with display formats" HTML book.
That should give you allot of background information on the subject.

HTH

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

<Siva> wrote in message news:4a37af22.4f6f.1681692777@sybase.com...
> Hi All
>
> i am new to powerbuilder
>
> i have datawindow column and it have format -
> $#,##0.00;[RED]($#,##0.00)
>
> Please tell me what it means What is ;[RED]
>
> and what is ($#,##0.00) same things in 2 different formate
>
> can any one explain me


Julián Tagarro Posted on 2009-06-17 12:56:18.0Z
From: "Julián Tagarro" <j-tagarro__AT__uolsinectis__DOT__com_DOT__ar>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a37af22.4f6f.1681692777@sybase.com> <4a37b2c7$1@forums-1-dub>
Subject: Re: $#,##0.00;[RED]($#,##0.00) what this format means
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
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: <4a38e7f2$1@forums-3-dub.sybase.com>
Date: 17 Jun 2009 05:56:18 -0700
X-Trace: forums-3-dub.sybase.com 1245243378 10.22.241.152 (17 Jun 2009 05:56:18 -0700)
X-Original-Trace: 17 Jun 2009 05:56:18 -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:89498
Article PK: 418689

Hi all

Chris .. I wonder where I can find this HTML book that you are talking
about. I also saw some reference to "PB .NET HTML Book". Is it the same book
?

--
Regards
Julián
Rosario Santa Fe Argentina

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:4a37b2c7$1@forums-1-dub...
> Hi Siva;
>
> PB uses standard MS-Excel display and edit mask patterns to control
> numeric data. In your case, the pattern before the ";" is positive and the
> part after the ";" is negative. The +ve pattern indicates a money value
> with zero suppression until the one dollar range. The -ve pattern uses a
> red colouring with the same zero suppression.
>
> For more information on these display/edit masks .. have a look at the
> PB Help file and search for "Display Format Dialog Box". You should find a
> link in that help section to the "Working with display formats" HTML book.
> That should give you allot of background information on the subject.
>
> HTH
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> <Siva> wrote in message news:4a37af22.4f6f.1681692777@sybase.com...
>> Hi All
>>
>> i am new to powerbuilder
>>
>> i have datawindow column and it have format -
>> $#,##0.00;[RED]($#,##0.00)
>>
>> Please tell me what it means What is ;[RED]
>>
>> and what is ($#,##0.00) same things in 2 different formate
>>
>> can any one explain me
>
>


Chris Pollach Posted on 2009-06-17 14:41:58.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a37af22.4f6f.1681692777@sybase.com> <4a37b2c7$1@forums-1-dub> <4a38e7f2$1@forums-3-dub.sybase.com>
Subject: Re: $#,##0.00;[RED]($#,##0.00) what this format means
Lines: 68
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; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a3900b6$1@forums-3-dub.sybase.com>
Date: 17 Jun 2009 07:41:58 -0700
X-Trace: forums-3-dub.sybase.com 1245249718 10.22.241.152 (17 Jun 2009 07:41:58 -0700)
X-Original-Trace: 17 Jun 2009 07:41: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:89507
Article PK: 418698

Hi Julián;

The links are in the PB Help file on the top tool bar .. it should say
"HTML Books". Clicking on that should give you a drop down of the ones
installed on your development system.

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Julián Tagarro" <j-tagarro__AT__uolsinectis__DOT__com_DOT__ar> wrote in
message news:4a38e7f2$1@forums-3-dub.sybase.com...
> Hi all
>
> Chris .. I wonder where I can find this HTML book that you are talking
> about. I also saw some reference to "PB .NET HTML Book". Is it the same
> book ?
>
> --
> Regards
> Julián
> Rosario Santa Fe Argentina
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:4a37b2c7$1@forums-1-dub...
>> Hi Siva;
>>
>> PB uses standard MS-Excel display and edit mask patterns to control
>> numeric data. In your case, the pattern before the ";" is positive and
>> the part after the ";" is negative. The +ve pattern indicates a money
>> value with zero suppression until the one dollar range. The -ve pattern
>> uses a red colouring with the same zero suppression.
>>
>> For more information on these display/edit masks .. have a look at the
>> PB Help file and search for "Display Format Dialog Box". You should find
>> a link in that help section to the "Working with display formats" HTML
>> book. That should give you allot of background information on the
>> subject.
>>
>> HTH
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> http://chrispollach.pbdjmagazine.com
>>
>>
>> <Siva> wrote in message news:4a37af22.4f6f.1681692777@sybase.com...
>>> Hi All
>>>
>>> i am new to powerbuilder
>>>
>>> i have datawindow column and it have format -
>>> $#,##0.00;[RED]($#,##0.00)
>>>
>>> Please tell me what it means What is ;[RED]
>>>
>>> and what is ($#,##0.00) same things in 2 different formate
>>>
>>> can any one explain me
>>
>>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-06-17 14:48:52.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a37af22.4f6f.1681692777@sybase.com> <4a37b2c7$1@forums-1-dub> <4a38e7f2$1@forums-3-dub.sybase.com> <4a3900b6$1@forums-3-dub.sybase.com>
Subject: Re: $#,##0.00;[RED]($#,##0.00) what this format means
Lines: 80
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
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: <4a390254@forums-3-dub.sybase.com>
Date: 17 Jun 2009 07:48:52 -0700
X-Trace: forums-3-dub.sybase.com 1245250132 10.22.241.152 (17 Jun 2009 07:48:52 -0700)
X-Original-Trace: 17 Jun 2009 07:48:52 -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:89509
Article PK: 418700

(Look on the Contents tab)

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:4a3900b6$1@forums-3-dub.sybase.com...
> Hi Julián;
>
> The links are in the PB Help file on the top tool bar .. it should say
> "HTML Books". Clicking on that should give you a drop down of the ones
> installed on your development system.
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> "Julián Tagarro" <j-tagarro__AT__uolsinectis__DOT__com_DOT__ar> wrote in
> message news:4a38e7f2$1@forums-3-dub.sybase.com...
>> Hi all
>>
>> Chris .. I wonder where I can find this HTML book that you are talking
>> about. I also saw some reference to "PB .NET HTML Book". Is it the same
>> book ?
>>
>> --
>> Regards
>> Julián
>> Rosario Santa Fe Argentina
>>
>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>> news:4a37b2c7$1@forums-1-dub...
>>> Hi Siva;
>>>
>>> PB uses standard MS-Excel display and edit mask patterns to control
>>> numeric data. In your case, the pattern before the ";" is positive and
>>> the part after the ";" is negative. The +ve pattern indicates a money
>>> value with zero suppression until the one dollar range. The -ve pattern
>>> uses a red colouring with the same zero suppression.
>>>
>>> For more information on these display/edit masks .. have a look at
>>> the PB Help file and search for "Display Format Dialog Box". You should
>>> find a link in that help section to the "Working with display formats"
>>> HTML book. That should give you allot of background information on the
>>> subject.
>>>
>>> HTH
>>>
>>> --
>>> Regards ... Chris
>>> ISUG - NA RUG Director
>>> http://chrispollach.pbdjmagazine.com
>>>
>>>
>>> <Siva> wrote in message news:4a37af22.4f6f.1681692777@sybase.com...
>>>> Hi All
>>>>
>>>> i am new to powerbuilder
>>>>
>>>> i have datawindow column and it have format -
>>>> $#,##0.00;[RED]($#,##0.00)
>>>>
>>>> Please tell me what it means What is ;[RED]
>>>>
>>>> and what is ($#,##0.00) same things in 2 different formate
>>>>
>>>> can any one explain me
>>>
>>>
>>
>>
>
>


Julián Tagarro Posted on 2009-06-17 15:36:56.0Z
From: "Julián Tagarro" <j-tagarro__AT__uolsinectis__DOT__com_DOT__ar>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a37af22.4f6f.1681692777@sybase.com> <4a37b2c7$1@forums-1-dub> <4a38e7f2$1@forums-3-dub.sybase.com> <4a3900b6$1@forums-3-dub.sybase.com>
Subject: Re: $#,##0.00;[RED]($#,##0.00) what this format means
Lines: 83
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; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a390d98@forums-3-dub.sybase.com>
Date: 17 Jun 2009 08:36:56 -0700
X-Trace: forums-3-dub.sybase.com 1245253016 10.22.241.152 (17 Jun 2009 08:36:56 -0700)
X-Original-Trace: 17 Jun 2009 08:36:56 -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:89510
Article PK: 418704

Ohh !! missed that part !!

Thanks for your reply.


--
Regards
Julián
Rosario Santa Fe Argentina

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:4a3900b6$1@forums-3-dub.sybase.com...
> Hi Julián;
>
> The links are in the PB Help file on the top tool bar .. it should say
> "HTML Books". Clicking on that should give you a drop down of the ones
> installed on your development system.
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> "Julián Tagarro" <j-tagarro__AT__uolsinectis__DOT__com_DOT__ar> wrote in
> message news:4a38e7f2$1@forums-3-dub.sybase.com...
>> Hi all
>>
>> Chris .. I wonder where I can find this HTML book that you are talking
>> about. I also saw some reference to "PB .NET HTML Book". Is it the same
>> book ?
>>
>> --
>> Regards
>> Julián
>> Rosario Santa Fe Argentina
>>
>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>> news:4a37b2c7$1@forums-1-dub...
>>> Hi Siva;
>>>
>>> PB uses standard MS-Excel display and edit mask patterns to control
>>> numeric data. In your case, the pattern before the ";" is positive and
>>> the part after the ";" is negative. The +ve pattern indicates a money
>>> value with zero suppression until the one dollar range. The -ve pattern
>>> uses a red colouring with the same zero suppression.
>>>
>>> For more information on these display/edit masks .. have a look at
>>> the PB Help file and search for "Display Format Dialog Box". You should
>>> find a link in that help section to the "Working with display formats"
>>> HTML book. That should give you allot of background information on the
>>> subject.
>>>
>>> HTH
>>>
>>> --
>>> Regards ... Chris
>>> ISUG - NA RUG Director
>>> http://chrispollach.pbdjmagazine.com
>>>
>>>
>>> <Siva> wrote in message news:4a37af22.4f6f.1681692777@sybase.com...
>>>> Hi All
>>>>
>>>> i am new to powerbuilder
>>>>
>>>> i have datawindow column and it have format -
>>>> $#,##0.00;[RED]($#,##0.00)
>>>>
>>>> Please tell me what it means What is ;[RED]
>>>>
>>>> and what is ($#,##0.00) same things in 2 different formate
>>>>
>>>> can any one explain me
>>>
>>>
>>
>>
>
>