We help IT Professionals succeed at work.

my value rounds up

242 Views
Last Modified: 2013-11-07
dim ierr_amt as decimal
 
 mytxtErr_Amt = CType(item.FindControl("txtERR_AMT"), TextBox)
                                    ierr_amt = mytxtErr_Amt.Text     'this point ierr_amt is 8534.88
                                   
                                   
                                    insert statement
                                    ByVal ierr_amt As Decimal
                                   
                                    aParms(3) = New SqlParameter("@ierr_amt", SqlDbType.Decimal)
                                       
                                        If ierr_amt = Nothing Then
                                            aParms(3).Value = DBNull.Value
                                        Else
                                            aParms(3).Value = ierr_amt  'this point also 8534.88
                                                  end if
                                                 
                                                 
                                                  When I go check database it is value is rounded up and saved that way 8435
                                                 
                                                 
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
what is the EXACT data type in the table? note also the precision and scale, you might have a 0 scale (hence 0 digits after the comma, hence rounding!)
CERTIFIED EXPERT
Top Expert 2010

Commented:
Check the data type of that column in the database.  Is it int or bigint?

Author

Commented:
it is MONY:numeric(10, 2)

Author

Commented:
I still didn't figure this out, what I need to do?
Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I add that still a problem
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
can you show then the command/procedure/insert statement that you use?

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.