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

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

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