Hello - How can I solve this ? IF STRLEN(gaut_XMLNodeFound.text) > 0 THEN … When parsing the XML content if a node is greater then …(1024) then Navision give the error <<< The length of the text string exceeds the size of the string buffer >>> The node is something like 2 3 4 5 … a lot more Is it another way to test if the node (parent) contains something ? Thanking you in advance.
Hi Use the XMLDom object, here is properties like count or childnodes.count. you can also use xpath to get an xmlnodelist returned and use count on this object.
this is one of those extremely rare questions, to which the answer is … wait for Navision 4.00
Could you give more precisions about V4.00 (xmlport, technology, anything available) ?
Could somebody give example of using XMLPort, or where I can get such information?
Hi all, I have a simple task to do - format an email body and put it in an external db for a separate process to send. I have it all working except for the critical part of creating the body - there I have come to a dead stop due to the message: “Length of the text string exceeds…” The email body grows directly proportional to the number of lines in the subject order. So, in order to append each formatted line to the body, I had to use the ADO Stream object as documented on this site, but I am unable to assign the text data from the Stream to a variant, in order for it to be passed as a parameter to the ADO Parameter object of a SQL stored procedure. From all the postings I have found here, it seems impossible! The only solution I haven’t tried is the one about creating an OCX / COM componenent. Before I start all that for such a trivial task, I want to confirm that it (incredibly) is really the only way it can be done.
Hi, I solved this problem of this way:
XlWrkSht.Range(‘IV3’).Formula := ‘=EXTRACT(’+xlColID + xlRowID+’;1;1000)’;
XlWrkSht.Range(‘IV4’).Formula := ‘=EXTRACT(’+xlColID + xlRowID+’;1001;1000)’;
XlWrkSht.Range(‘IV5’).Formula := ‘=EXTRACT(’+xlColID + xlRowID+’;2001;1000)’;
locTextLargo1 := FORMAT(XlWrkSht.Range(‘IV3’).Value);
locTextLargo2 := FORMAT(XlWrkSht.Range(‘IV4’).Value);
locTextLargo3 := FORMAT(XlWrkSht.Range(‘IV5’).Value);
I assume that IV3 IV4 and IV5 cells are empty and put in them the formula that extract the substrings and then I can read them.