Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

DB Tool Issue

tapan1986
tapan1986 Posts: 27 ✭
in SOAtest

I am using DB tool to retrieve data from SQL Server.
In DB the value is 0.0000003 but while returning in soatest it shows as below
3.00000E-7

Not sure about the conversion.Could you pls check and confirm.

Tagged:

Comments

  • benken_parasoft
    benken_parasoft Posts: 1,297 ✭✭✭
    edited December 2019

    Isn't 0.0000003 is the same as 3.00000E-7? I don't think the database stores the value as text but as a floating point number. So, neither textual representation is incorrect.

    If, for example, you want to validate a floating point value then you could do a numerical comparison (not a text comparison). You could do this with the "Numeric Assertion" from the XML Assertor, for example.

Categories

Tagged