DB Tool Issue

Options
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,392 ✭✭✭
    edited December 2019
    Options

    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