tag:blogger.com,1999:blog-913534236606046272.post2204980885936459539..comments2023-12-12T19:23:36.544+13:00Comments on movex blog: Building a M3 Web Service over an API and SQL Server's FOR XMLAlhttp://www.blogger.com/profile/06469996988980345250noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-913534236606046272.post-30504674453311156862018-12-11T00:21:51.226+13:002018-12-11T00:21:51.226+13:00regarding web-service I have a specific problem re...regarding web-service I have a specific problem regarding MMS100, where the "to warehouse is on the F-panel AND DOES NOT EXISTS IN E PANEL in web-service framework, BASED ON ORDER TYPE CONFIG SYSTEM IS EITHER CALLING E PANEL (FOR REQUISTION) AND F PANEL (FOR DISTRIBUTION). Have you heard about this problem before - and have you got a solution to come across it ??Mohamed Sithikhttps://www.blogger.com/profile/11992086851943822856noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-28805178559130296292015-06-11T15:53:51.559+12:002015-06-11T15:53:51.559+12:00Using bcp in this way can be a problem when you wa...Using bcp in this way can be a problem when you want to generate large xml files. There is a hard limit of 8000 characters to the string bcp can execute. To get around this you can generate the XML and insert this into a table rather than converting back to text.<br /><br />Then you end up with<br /><br />select @CMD = 'bcp "select XmlColumn from XmlTable where XmlID = ' + @ID + ' " queryout "' <br /><br />etc etcAnonymoushttps://www.blogger.com/profile/05460666893713525720noreply@blogger.com