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

["Ashish Bhatt" <ashish_bhatt@hotmail.com>]

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