Method Community

 

It does not appear the field exists in the table.

Last post 02-06-2009 4:22 PM by Method_Paul. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-03-2009 3:32 PM

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

    It does not appear the field exists in the table.

    I am trying to insert records into the Activity table. Amongst some "Success" responses, I also get "It does not appear the field  exists in the table." 

    Is there any way of finding out what the problem is here? I am not trying to add any fields with no name.


    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:


        


  • 02-06-2009 4:22 PM In reply to

    Re: It does not appear the field exists in the table.

    Matt - sorry, this post fell through the cracks.

    You are most likely receiving that message because you passed an empty field name. 

    My guess is that you split a comma separated string into an array, and the last field still had a "," after it.

    For example:

    field1,field2,field3,".Split(",")

    would actually create an array of 4 values, the last being empty.

    So instead if you made it:

    field1,field2,field3".Split(",")

    There would only be 3 in the array.

    That's my guess anyway, since I have had this happen before, and it is always a typo I've made.

    Side note - sure am glad we turned these techie topics into a separate forum! :)

    HTH,

    Paul

Page 1 of 1 (2 items)