Re: [sqr-users] Why no decimal in Insert ?

["Larry Roux" <LRoux@syr.edu>]

The number is being stored correctly.  Your select needs to tell the format you 
want the output to be displayed in.  Most ouputs default to "do not show the 
decimal portion if it does not exist".  You need to format the field on the 
select.


******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************

>>> ashish_bhatt@hotmail.com 06/05/03 12:44PM >>>
the program is just inserting integer value.

it is inserting 12345 I want it to insert 123435.00.

In select on table it shows me 12345


>From: "Larry Roux" <LRoux@syr.edu>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] Why no decimal in Insert ?
>Date: Thu, 05 Jun 2003 12:21:51 -0400
>
>Are you saying that the program is not inserting the values beyond the 
>decimal or that when you run a select you do not see them?
>
>
>
>
>******************************
>Larry Roux
>Syracuse University
>lroux@syr.edu
>*******************************
>
> >>> ashish_bhatt@hotmail.com 06/05/03 11:58AM >>>
>Hi SQR Gurus,
>
>I hope you are doing fine today.
>
>I have below sqr code for insert into ps_DEDUCTION_BAL table.
>
>It does not show decimal in the column DED_YTD when I select the data of
>ps_DEDUCTION_BAL table.
>
>Below show statement shows the value of #DED_YTD with decimal.
>
>I tried putting to_number for DED_YTD. But no luck.
>
>
>    let #DED_YTD = $DED_YTD
>
>show '#DED_YTD: ' #DED_YTD
>
>begin-SQL on-error=WARN
>
>Insert into ps_DEDUCTION_BAL
>        (Emplid,
>         COMPANY,
>         BALANCE_ID,
>         BALANCE_YEAR,
>         BALANCE_QTR,
>         BALANCE_PERIOD,
>         BENEFIT_RCD_NBR,
>         PLAN_TYPE,
>         BENEFIT_PLAN,
>     DEDCD,
>     DED_CLASS,
>     DED_YTD,
>     DED_QTD,
>     DED_MTD)
>Values ($oEmplid,
>         $oCOMPANY,
>     $BALANCE_ID,
>     $BALANCE_YEAR,
>     $BALANCE_QTR,
>     $BALANCE_PERIOD,
>     $BENEFIT_RCD_NBR,
>     $oPLAN_TYPE,
>     nvl($oBENEFIT_PLAN,' '),
>     $oDEDCD,
>     $oDED_CLASS,
>     #DED_YTD,
>     #DED_QTD,
>     #DED_MTD)
>end-sql
>
>Please reply.
>
>Thanks in advance.
>
>Have a nice day and great week.
>
>Regards.
>
>Ashish Bhatt.
>
>_________________________________________________________________
>Download Norah Jones, Eminem and more! http://www.msn.com.sg/ringtones/ at
>only S$36 including GST
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Send a fun phone greeting to your friend! 
http://www.msn.com.sg/mobile/fungreetings/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users