SPONSORS:






User Tag List

Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Oct 2001
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SilkTest is rounding numbers up, when using XLS!!! (Help Please)

    Hi All,
    I am facing a problem when trying to get long numbers from Excel, by using an ODBC connection to that XLS sheet.

    So, when I try to get 0.0816500 via the DB_ExecuteSQL, it will return 0.0817!!!.

    Here is the code:
    hSQL = DB_ExecuteSQL (hDB, "SELECT ZZZ from `MySheet$` where Main=5")
    [-] while DB_FetchNext (hSQL,ZZZ)
    [ ] print (ZZZ)

    When I run this code, I get 0.0817!!! and not the full number.

    Note: I tried to define ZZZ as interger, real, number, anytype ... and still getting the same problem.


    Best Regards,
    SilkPerf

  2. #2
    Junior Member
    Join Date
    May 2001
    Location
    Sophia-Antipolis, France
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SilkTest is rounding numbers up, when using XLS!!! (Help Please)

    Hi,

    I've experienced the same problem, but my numbers are truncated to 6 decimal places. So, it is interesting to know, as it means that it should be possible somewhere to configure this.
    The workarround we found is to format your cells as text (put a quotation mark before your number in the cell).
    That workarround causes problems if your numbers are the results of calculations within the worksheet.

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

  3. #3
    AJ
    AJ is offline
    Moderator AJ's Avatar
    Join Date
    Jun 1999
    Location
    San Jose, CA
    Posts
    1,691
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SilkTest is rounding numbers up, when using XLS!!! (Help Please)

    silkperf, read the gregistration email again if you want to keep using the site, and also read the FAQ http://www.qaforums.com/faq.html
    AJ Alhait
    BetaSoft Inc.

 

 

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 04:14 PM.

Copyright BetaSoft Inc.