SPONSORS:






User Tag List

Page 1 of 4 1234 LastLast
Results 1 to 10 of 31
  1. #1
    Member
    Join Date
    May 2001
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    \'Numeric field overflow\' error in DB_FetchNext..

    Hi,
    I am Getting 'Numeric field overflow'. The Excel Spread sheet has 15 Columns.
    What I am trying to do is
    1.Populating the 15 variables with 15 columns data, which is retrieved from excel.
    2.Populating the testfields & selecting the data from popup list boxes according to those 15 variable values. I am attaching the Script File. Any help will be appreciated.



    [This message has been edited by mansri (edited 06-13-2001).]

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

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    Sounds like one of the values being read in is too large for the variable it is being read into. If your variables are integers, then they have a maximum value of 2147483647; if you want to hold a larger value than this, you will need to read it into a floating-point variable (use Real or Number).

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

  3. #3
    Senior Member
    Join Date
    Sep 2000
    Location
    Twin Cities, MN, USA
    Posts
    653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    Another thing you may want to look into is reinstalling the MDAC on your machine.
    http://www.microsoft.com/data/

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

  4. #4
    Member
    Join Date
    May 2001
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    Hi Vince,
    The data does not have large values. I found that I am getting this error on 13th variable. The variable values something like 'exon'. If I remove the variable value, I am not getting this problem.

    Hi, Steve
    I have installed MDAC2.6 SDK. But still having the problem.
    I am using Sik 5.0.3.1 on WinNT.

    [This message has been edited by mansri (edited 06-14-2001).]

    [This message has been edited by mansri (edited 06-14-2001).]

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

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    The value you're getting from the spreadsheet is a string, but you're getting a numeric overflow error? Odd. Are the variables you're reading into (the parameters to DB_FetchNext()) strings also?
    What happens if you make all those variables anytype?

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

  6. #6
    Senior Member
    Join Date
    Jan 2001
    Posts
    750
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    Leave your DB_FetchNext() loop empty and run your script see if you have any error.

    Also, I am not sure what are you doing here:

    DB_ExecuteSql (HDB,"INSERT INTO `Results$`(x,y) VALUES ('{p1}','{sRecords}'")
    Are inserting back to the same table while you are reading from it????


    Is this error on the read part or insert part??

    Strip your code to the basic and add new code to it little by little.

    My guess is

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

  7. #7
    Member
    Join Date
    May 2001
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    Hi vincebowdren,
    I changed the parameter data type from strings to anytype. Still same problem.

    Hi Gk,
    I am getting the error in the Reading part. I am exporting the results to the same spreadsheet, but to different Sheet.
    I mean I reading Values from 'Sheet1' and inserting results to 'Sheet2'.
    I am executing other test case this way, they are working fine. (With two values.)


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


    [This message has been edited by mansri (edited 06-14-2001).]

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

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    This is very odd indeed. How about if you just pass in a list of string (or a list of anytype) instead of separately specifying each variable?
    Can we have a look at one of your results files?


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

  9. #9
    Member
    Join Date
    May 2001
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    Hi vincebowdren,
    Before I post this problem, I tried with list of anytype. I got the same problem.
    I am not sure I can post my 'Results' file or not. I cannot send my application either.
    Security issues. I am with this.


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


    [This message has been edited by mansri (edited 06-14-2001).]

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

    Re: \'Numeric field overflow\' error in DB_FetchNext..

    Well I'm running out of ideas I'm afraid. To be honest, I just wanted to look at the results file to comfirm that it did say the error was happening in DB_FetchNext; does it look like an internal silktest error, or an error returned from the odbc driver?
    Have you tried executing the same sql query through a different odbc client (there is one available in the downloads section of this site)?
    Maybe you could try changing the query to only retrieve the values from selected columns; starting from just one, you can increase the number of columns until the error starts happening, and then it might be more obvious what's going wrong.

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

 

 
Page 1 of 4 1234 LastLast

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:23 PM.

Copyright BetaSoft Inc.