SPONSORS:






User Tag List

Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Aug 2001
    Location
    United Kingdom
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Rounding of values when using DB_Tester

    We are using SilkTests's DB_Tester to verify values in a SQL database. We want to verify an actual value in the DB with an expected value.

    If our expected value is 40952.76 and the value in the DB is also 40592.76 we should expect these values to match and the test to pass. However, the value returnedfrom the DB by Silk is 40592.80000. This obviously causes a mis-match and the test fails.
    When we examine the DB manually the value is displayed as 40952.76.

    Why is Silk returning a value which appears to be rounded up and how can we prevent this?

    ------------------

  2. #2
    Super Member
    Join Date
    Jul 2001
    Location
    Earth
    Posts
    1,882
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Rounding of values when using DB_Tester

    A few things to try....

    1 - Read the value from the DB into a string and then use Val() to convert it into a REAL.

    2 - Make sure the the ODBC driver you are using does not have a setting to round numbers.

    ------------------
    James Soderborg
    http://www.ameliortech.com
    jamesso@ameliortech.com

  3. #3
    Senior Member
    Join Date
    Aug 1999
    Location
    Cambridge, UK
    Posts
    470
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Rounding of values when using DB_Tester

    It's a known bug I'm afraid; see the description I made of it at http://www.qaforums.com/Forum1/HTML/001739.html. As far as I know segue haven't fixed it yet.

    ------------------

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 02:21 PM.

Copyright BetaSoft Inc.