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 bug in PB 11.2 Build 8869

2 posts in DataWindow Last posting was on 2009-11-02 21:36:37.0Z
mhampton Posted on 2009-11-02 20:30:00.0Z
From: mhampton <mdhampton@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Format bug in PB 11.2 Build 8869
Date: Mon, 2 Nov 2009 12:30:00 -0800 (PST)
Organization: http://groups.google.com
Lines: 13
Message-ID: <d4875250-2794-45ce-9de2-61ceefd798cd@p28g2000vbi.googlegroups.com>
NNTP-Posting-Host: 70.62.223.68
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1257193800 8063 127.0.0.1 (2 Nov 2009 20:30:00 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 2 Nov 2009 20:30:00 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: p28g2000vbi.googlegroups.com; posting-host=70.62.223.68; posting-account=1slC8woAAAA_hCZuBpZhfWINwjNAZy9w
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.4) Gecko/20091016 Firefox/3.5.4 (.NET CLR 3.5.30729),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!newsfeed.news2me.com!nx01.iad01.newshosting.com!newshosting.com!news.glorb.com!postnews.google.com!p28g2000vbi.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90195
Article PK: 409800

Using SQL Server 2008 with OLEDB and provider = SQLNCLI. Not sure if
it applies to all databases and external source datawindows.

On a numeric (in this case either a Money or Decimal from the
database) column, this format rounds to nearest dollar: #,###.0000

If you change it to either of these, it will no longer round to
nearest dollar:
#,##0.0000
####.0000


mhampton Posted on 2009-11-02 21:36:37.0Z
From: mhampton <mdhampton@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Format bug in PB 11.2 Build 8869
Date: Mon, 2 Nov 2009 13:36:37 -0800 (PST)
Organization: http://groups.google.com
Lines: 18
Message-ID: <0d1dd0bd-4d23-48ce-93a2-934465e6c0b6@v36g2000yqv.googlegroups.com>
References: <d4875250-2794-45ce-9de2-61ceefd798cd@p28g2000vbi.googlegroups.com>
NNTP-Posting-Host: 70.62.223.68
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1257197797 27110 127.0.0.1 (2 Nov 2009 21:36:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 2 Nov 2009 21:36:37 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v36g2000yqv.googlegroups.com; posting-host=70.62.223.68; posting-account=1slC8woAAAA_hCZuBpZhfWINwjNAZy9w
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.4) Gecko/20091016 Firefox/3.5.4 (.NET CLR 3.5.30729),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!newsfeed.news2me.com!nx02.iad01.newshosting.com!newshosting.com!feed.news.qwest.net!mpls-nntp-04.inet.qwest.net!news.glorb.com!postnews.google.com!v36g2000yqv.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90197
Article PK: 409801


On Nov 2, 3:30 pm, mhampton <mdhamp...@gmail.com> wrote:
> Using SQL Server 2008 with OLEDB and provider = SQLNCLI. Not sure if
> it applies to all databases and external source datawindows.
>
> On a numeric (in this case either a Money or Decimal from the
> database) column, this format rounds to nearest dollar: #,###.0000
>
> If you change it to either of these, it will no longer round to
> nearest dollar:
> #,##0.0000
> ####.0000

More information:

This format also doesn't work: ##,###.0000
Having six or more # will however fix the issue.

Do you ever test formats? Why do they always seem to break?