Article View: borland.public.jbuilder.database
Article #292Aggregate column
From: ivan.lusavec
Date: Thu, 02 Mar 2006 19:33
Date: Thu, 02 Mar 2006 19:33
11 lines
1539 bytes
1539 bytes
Hi. I have noticed that when using SumAggOperator on BigDecimal column with defined scale as 3 it sums only two decimal places, and it gives me very very wrong results. When i use MaxAggOperator it "finds" BigDecimal with three decimal places. So is this normal behavior , I need this to sum quantity.Right now i am using loadRow Event to imitate sum which gives me right result, but if possible I would like to use SumAggOperator. And yes aggregated column has also scale set to 3, but it looks like it is just ignoring it. Must I write my own Sum operator, would it help, did someone try that. Thx in advance bye.
Technical Details
Message-ID:
<44074874@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 1073da,49fe709c1bde775c,start X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: <ivan.lusavec@inet.hr> From: <ivan.lusavec@inet.hr> Newsgroups: borland.public.jbuilder.database Subject: Aggregate column Date: Thu, 2 Mar 2006 20:33:34 +0100 Lines: 13 Organization: aa X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 NNTP-Posting-Host: 213.202.87.153 Message-ID: <44074874@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1141327988 213.202.87.153 (2 Mar 2006 11:33:08 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail