#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2008
    Posts
    12
    Rep Power
    0

    Real type calculation fields


    Hi, I use Firebird 2.5. I have a computing in my view. It can calculate but
    there are a lot of number decimally. For example result should be "2.03" but
    firebird send me "2.00000003" I want to see 2 digit after point. How can I set
    it?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2007
    Posts
    36
    Rep Power
    8
    Originally Posted by AhmetNuri
    Hi, I use Firebird 2.5. I have a computing in my view. It can calculate but
    there are a lot of number decimally. For example result should be "2.03" but
    firebird send me "2.00000003" I want to see 2 digit after point. How can I set
    it?
    In the definition of your view , you can put a cast on the field that is a computing :

    cast(sum(....) as numeric(15,2))

IMN logo majestic logo threadwatch logo seochat tools logo