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.

datawindow rounding

3 posts in DataWindow Last posting was on 2008-08-29 13:32:43.0Z
Wolf Posted on 2008-08-28 17:14:06.0Z
Sender: 536a.48b6dbf2.846930886@sybase.com
From: Wolf
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: datawindow rounding
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48b6dcde.538a.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Aug 2008 10:14:06 -0700
X-Trace: forums-1-dub 1219943646 10.22.241.41 (28 Aug 2008 10:14:06 -0700)
X-Original-Trace: 28 Aug 2008 10:14:06 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87662
Article PK: 416918

I have created a datawindow with update for some numbers.
The database field is number(7,2). No mater what I try,
when numbers are entered the round to the nearest whole
number. What am I doing wrong?


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-08-28 17:29:05.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48b6dcde.538a.1681692777@sybase.com>
Subject: Re: datawindow rounding
Lines: 17
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: <48b6e061$1@forums-1-dub>
Date: 28 Aug 2008 10:29:05 -0700
X-Trace: forums-1-dub 1219944545 10.22.241.152 (28 Aug 2008 10:29:05 -0700)
X-Original-Trace: 28 Aug 2008 10:29:05 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87663
Article PK: 416919

It would be helpful to know what DBMS you are using.
It sounds like the definition in the DW does not match the DBMS. Was the
definition changed in the schema?
You can make PB recheck the definition by opening the DW, making and
reversing any change to the SQL (graphic mode drag the column order and put
it back, syntax mode add and remove a space) and saving the DW. Look at the
column definitions to see what PB is using as the definition.
It might also be possible that the edit for the column does not allow
decimals.

<Wolf> wrote in message news:48b6dcde.538a.1681692777@sybase.com...
>I have created a datawindow with update for some numbers.
> The database field is number(7,2). No mater what I try,
> when numbers are entered the round to the nearest whole
> number. What am I doing wrong?


Wolf Posted on 2008-08-29 13:32:43.0Z
Sender: 7e0b.48b7f84b.1804289383@sybase.com
From: Wolf
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: datawindow rounding
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48b7fa7a.7e3f.1681692777@sybase.com>
References: <48b6e061$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Aug 2008 06:32:43 -0700
X-Trace: forums-1-dub 1220016763 10.22.241.41 (29 Aug 2008 06:32:43 -0700)
X-Original-Trace: 29 Aug 2008 06:32:43 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87668
Article PK: 416924

The database is Oracle 10g. The field was a floating poing
number without specific number of decimals when the
datawindow was created. I had modified the field to
number(7,2).

I have now regenerated the sql for the datawindow and it is
working.

Thanks for your help.