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.

strange behaviour in computed field expression

2 posts in DataWindow Last posting was on 2008-08-26 17:18:55.0Z
Martin Posted on 2008-08-08 09:07:13.0Z
From: "Martin" <m.kaltenboeck@utanet.at>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: strange behaviour in computed field expression
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <489c0cc1@forums-1-dub>
Date: 8 Aug 2008 02:07:13 -0700
X-Trace: forums-1-dub 1218186433 10.22.241.152 (8 Aug 2008 02:07:13 -0700)
X-Original-Trace: 8 Aug 2008 02:07:13 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87526
Article PK: 416782

I just migrated my app from PB 10.5.1 build 6684 to 10.5.2 build 7699.
(Winxp LanguageSettings: German)

i have a datawindow containing the expression: round(decimalvalue * 1.2, 2).

in 6684 it evaluated correkt (example: decimalvalue = 100 -> evaluated
120)

in 7699 it fails (example: decimalvalue = 100 -> evaluated 100)

it seems that the part '.2' is simply ignored.

the verfiy button says 'expression is ok'.

I tried to use brackets (1.2), but no change

I worked arround by 'round(decimalvalue * 120 / 100, 2)',
but i would like to know what's the matter with this?

Thank you for help


"John Olson [Team Sybase]" <john.olson Posted on 2008-08-26 17:18:55.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <489c0cc1@forums-1-dub>
Subject: Re: strange behaviour in computed field expression
Lines: 101
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0032_01C90765.1BA8ABE0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48b43aff$1@forums-1-dub>
Date: 26 Aug 2008 10:18:55 -0700
X-Trace: forums-1-dub 1219771135 10.22.241.152 (26 Aug 2008 10:18:55 -0700)
X-Original-Trace: 26 Aug 2008 10:18:55 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87641
Article PK: 416897

If it works in one version but not in the next then it's most likely a regression bug and should be reported.
 
Just out of curiousity, did you try:
 
round((decimalvalue * 1.2), 2)
 
Regards,
John
Team Sybase
 
"Martin" <m.kaltenboeck@utanet.at> wrote in message news:489c0cc1@forums-1-dub...
>I just migrated my app from PB 10.5.1 build 6684 to 10.5.2 build 7699.
> (Winxp LanguageSettings: German)
>
> i have a datawindow containing the expression: round(decimalvalue * 1.2, 2).
>
> in 6684 it evaluated correkt    (example: decimalvalue = 100 -> evaluated
> 120)
>
> in 7699 it fails (example: decimalvalue = 100 -> evaluated 100)
>
> it seems that the part '.2' is simply ignored.
>
> the verfiy button says 'expression is ok'.
>
> I tried to use brackets (1.2), but no change
>
> I worked arround by 'round(decimalvalue * 120 / 100, 2)',
> but i would like to know what's the matter with this?
>
> Thank you for help
>
>