Re: Negative Number -Reply

[Ali Dosani <adosani@YAHOO.COM>]

Try using the sign function in the edit and also make sure the
datatype accomodates -ve nos in the database.




---"McClure, John" <john.mcclure@WILCOM.COM> wrote:
>
> yes
>
>  LET #PSFIN.PS_HR_WRK_TBL_WX.MONETARY_AMOUNT =
>  to_number($new_amt) / 100
>
> Thanks
>
> John McClure
> Williams Communications Solutions
> Office:  (713)307-4318
> Pager:  (888)740-0554
> Email:   john.mcclure@wilcom.com
>
> > -----Original Message-----
> > From: David Anderson [SMTP:DANDERS1@SMTPGW.IS.HFH.EDU]
> > Sent: Wednesday, February 17, 1999 2:18 PM
> > To:   Multiple recipients of list SQR-USERS
> > Subject:      Negative Number -Reply
> >
> > This is probably nit-picky, but your code indicates you are using a
> > variable called $new_amt.  Are you certain you are using $new_amt in
> > your insert statement (vs $TL_GLADD.GLADD.amount).
>

==
Dosani Ali

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com