Re: Rounding.. please help

[Robert Goshko <robert.goshko@AXIS-DEV.COM>]

Steve,

The rounding function in SQR 3 doesn't work correctly on some number, and
this is documented by SQRIBE, with a workaround that PeopleSoft has
implemented (it has to do with the way number are stored by SQR internally).

Jonathan,

I have use PeopleSofts PS_SQR_ROUND and PS_SQR_TRUNC functions, and they
worked in my instance, possible check out the SQRIBE problem database to see
if something is wrong with PeopleSofts implementation of the fix?

......Rob
_________________________________________________
Robert Goshko <mailto:robert.goshko@axis-dev.com>
Owner
Axis Developments
System Consulting Services
Sherwood Park, Alberta, Canada
http://www.axis-dev.com/


> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Steven E. Davies
> Sent: Wednesday, September 23, 1998 7:07 AM
> To: Multiple recipients of list SQR-USERS
> Subject: Re: Rounding.. please help
>
>
> Jonathan,
>
> Is there a reason why you aren't using the internal SQR round()
> function?
>
> Example:
>
> let #num = 12.123456
>
> let #rnd = round(#num, 0)   ! #rnd = 12
> let #rnd = round(#num, 1)   ! #rnd = 12.1
>
> HTH
>
> Steve
>
> ---Jonathan Fry <frydaddy@BELLSOUTH.NET> wrote:
> >
> > I posted a cry out for help last week, but haven't been able to get
> any
> > answers. I'm having a problem rounding numbers. When I call
> > ps_sqr_round, my program just loops within the sqc. Since my last
> post,
> > I narrowed down the problem to it only happening when I run off of
> unix.
> > Anyone had this problem before? I'm in contact with some PeopleSoft
> > people, but have yet to receive a resolution.
> >
> > I'm using SQR version 3.0. Any help is much appreciated.
> >
> > Thanks.
> >
> > Jonathan
> >
>
> ==
>
>
> Steven E. Davies
> ------------------------------
> "Quid quid latine dictum sit,
>  altum viditur."
> ------------------------------
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>