We have an application that creates XML file using text endtext code - see below. In a recent case VFP but an extra carriage return line feed in the </charge_desc> delimiter - all other records in the file were ok. Has anyone experienced anything like this? Here is code
&& put into txt file
TEXT noshow
<fee>
<charge_date><<lcdate>></charge_date>
<tk_id><<ALLTRIM(STR(ctran1cur.lawyer))>></tk_id>
<charge_desc><<lcdescr>></charge_desc>
<acca_task><<lctask>></acca_task>
<acca_activity><<lcactivity>></acca_activity>
<charge_type>U</charge_type>
<units><<lcunits>></units>
<rate><<lcunitcost>></rate>
<base_amount>lcitemtotal</base_amount>
<total_amount><<lcitemtotal>></total_amount>
</fee>
ENDTEXT
00002dd5:64 61 6d 61 67 65 3c 2f 0d 0a 63 68 61 72 67 65 damage</..charge
00002de5:5f 64 65 73 63 3e _desc>
The carriage return line fee after the </ was inserted by VFP - all other xml records in the file were correct with just </charge_desc>.
Could this be something to do with line length or file length. The line in question had 235 characters of text in lcdescr - is there a limit on line length of 255?
&& put into txt file
TEXT noshow
<fee>
<charge_date><<lcdate>></charge_date>
<tk_id><<ALLTRIM(STR(ctran1cur.lawyer))>></tk_id>
<charge_desc><<lcdescr>></charge_desc>
<acca_task><<lctask>></acca_task>
<acca_activity><<lcactivity>></acca_activity>
<charge_type>U</charge_type>
<units><<lcunits>></units>
<rate><<lcunitcost>></rate>
<base_amount>lcitemtotal</base_amount>
<total_amount><<lcitemtotal>></total_amount>
</fee>
ENDTEXT
00002dd5:64 61 6d 61 67 65 3c 2f 0d 0a 63 68 61 72 67 65 damage</..charge
00002de5:5f 64 65 73 63 3e _desc>
The carriage return line fee after the </ was inserted by VFP - all other xml records in the file were correct with just </charge_desc>.
Could this be something to do with line length or file length. The line in question had 235 characters of text in lcdescr - is there a limit on line length of 255?