LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  ORacle JDBC MAthematic representation of bDouble variable

    Employee
    Posted 07-25-2012 06:55

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Michael.Slowey@lavastorm.

    Hi,

    I am extracting data from an oracle database and this is happening to certain instances of a bDouble variable...

    CHARGE
    1.583333
    1.666667
    4.00E-06


    Any ideas why one instanc is bing held in a mathematical format?

    Regards
    Mick


  • 2.  RE: ORacle JDBC MAthematic representation of bDouble variable

    Employee
    Posted 07-25-2012 08:42

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tim Meagher

    Do you mean that the BRDViewer is just displaying it in scientific notation?
    If it's a bdouble field, & shows double in the metadata, then it will be stored in a double format.
    How the BRDViewer displays it is another matter & my guess would be that the BRDViewer is just using a string representation of the double, which - depending on which API it is using and what the value of the double it - might display using scientific notation or not.