Method Community

 

Error in MethodAPIinsert

Last post 06-02-2009 11:49 AM by Anonymous. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 05-31-2009 12:02 PM

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Error in MethodAPIinsert

    I get the above error (just did it now). Can you shed some light on the problem please.


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 05-31-2009 10:52 PM In reply to

    Re: Error in MethodAPIinsert

     Matt,

    The value you are passing for QXDEstManHrs has quit a few decimal places. Round the value to no more than 4 decimal places.

    Peter

  • 06-01-2009 7:47 AM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Re: Error in MethodAPIinsert

    Thanks for the quick reply.

    I tried rounding down to 4 decimal points and then 2 and I'm still getting the same error.


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 06-01-2009 7:59 AM In reply to

    Re: Error in MethodAPIinsert

     Matt,

    The only other option I can think of is to change the value of True to 1 for QXDIsIncludedOnInvoice.

    If that doesn't work then if you don't mind I can go into your database and directly run the query and I can figure out
    exactly what is the problem as currently the error message I'm getting is a little vague.

    Pete

  • 06-01-2009 11:08 AM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Re: Error in MethodAPIinsert

    Found the problem. I had QXDEstManhrs as an integer not a decimal.


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 06-02-2009 11:49 AM In reply to

    Re: Error in MethodAPIinsert

     Thanks Matt,

    I've added some error catching to the API to give the user some a more informative message when this happens again.

    Pete

Page 1 of 1 (6 items)