XML string longer than 1024 chars?

wester

Hi there

I wish to create an XML-string from Navision 3.70 (native).
To build the XML string I've created a text-variable (1024 chars), and then loop through a table appending to the string.

When done, the string is inserted in a NTEXT-field in an external MS SQL Server 2000 database using automation. This database is serving a website, and has nothing to do with Navision in particular.

Everything seems to work just fine... until the length of the string in Navision exceeds 1024 chars!

How can I solve this? I have no XMLPorts, BigText-vars etc. since this is Navision 3.70

pduck

i don't think that there will be another solution then using automation objects like ms xml dom ... have a look here for an example:

http://www.mibuso.com/forum/viewtopic.p ... ht=xml+dom

try to search for "xml dom" in the forum ...

poloba

try tu use a Stream Object

DenSter

I agree, use the MSXMLDOM object. Check out the Biztalk codeunits for examples of how to use it.