DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL ERROR IN SELECT STATEMENT

  1. #1
    JOEY Guest

    SQL ERROR IN SELECT STATEMENT


    Hi,

    I am getting an error 8417.."scale of a numeric data value was truncated".

    It's occuring on a simple select statement where a table field is being
    "SELECT"ed into a table defined field
    The field has the following characteristics
    FIELDA NUMERIC (6,2) UNSIGNED NO DEFAULT NOT NULL,

    The select statement works when the value is an integer number EX:2
    But returns the error when it's a whole number EX: 2.57

    Anybody have any ideas???????


  2. #2
    Simon Sellick Guest

    Re: SQL ERROR IN SELECT STATEMENT


    "JOEY" <JOSEPH.VICTORIA@EMERGIS.COM> wrote:
    >
    >Hi,
    >
    >I am getting an error 8417.."scale of a numeric data value was truncated".
    >
    >It's occuring on a simple select statement where a table field is being


    >"SELECT"ed into a table defined field
    >The field has the following characteristics
    >FIELDA NUMERIC (6,2) UNSIGNED NO DEFAULT NOT NULL,
    >

    - is this the source or the destination? how does it compare with the other
    one?

    >The select statement works when the value is an integer number EX:2
    >But returns the error when it's a whole number EX: 2.57
    >

    - do you mean when it's NOT a whole number? and might this be a rounding
    problem - i.e. the value is really something like 2.569, so it has to be
    truncated to fit the destination?

    >Anybody have any ideas???????
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center