SQLWrite() statement shows no queries

Follow

Comments

3 comments

  • Avatar
    Jason Hoyt

    Oh, additional information - I am trying to write to a table that was added in as a test. The table does exist and everything points to it just fine.

  • Avatar
    Jason Hoyt

    Apologies, the first comment did not take leaving the above comment rather out of place.

    If all of the XML has been checked and the SQL statement runs correctly on its own is there anything else that will keep this from showing up? Namely is there a length limit on the sql="" part of the xml definition?

  • Avatar
    Thomas Heafner

    I have found that there is a 1092 character limit in the .xml file for it to be available in the procedure. I counted including my xml tag code, maybe it's only the SQL data.....but yes there is a limit around 1100.

Please sign in to leave a comment.