This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to get value which has type "Double" and the value has 2 or 3 digits after decimal from a database?


I am using COnnection.GetSingleProperty to read the value of "RiskIndex" from "AERole" table and the risk index is "0.01". Connection.GetSingleProperty as Double returns 0 instead of 0.01. How to handle this?

Parents Reply
  • Ident_AErole is not a unique property.  So I would suspect that you are getting more than one result, and something in your cast is broken.  I'd try something more like:

    public function TestDouble() As Double
        Dim dbRole as IEntity

        dbRole = Session.Source.Get("AERole","QER-AEROLE-CUSTOMADMIN-ADMIN")

        return dbRole.getvalue("RiskIndex").Double
    End function

    Or create a collection object and iterate through