Xml Delete Rows

[xnanx 0]

Hello to all,

Have a query like the following.

Running smoothly

I'm deleting places to SL_DETAILS.

sub ProcessEvent(App)    okay=App.Doc.FirstChild("TRANSACTIONS.TRANSACTION")    while okay          sType = App.Doc.FieldAsInteger("TRANSACTIONS.TRANSACTION.TYPE")          if sType= 0 then             App.Doc.RemoveChild "SL_DETAILS"          end if          if sType= 1 then             App.Doc.RemoveChild "SL_DETAILS"          end if          okay=App.Doc.NextChild    wend    App.Doc.SaveDataend sub

xml file has changed.

was as follows "SL_DETAILS"but could not erase.

 

How I can write as a below query for new query?

</MAPPED_CODE>			</SOURCEINDEX_MAPPEDS>		</TRANSACTION>				<TRANSACTION>					<TYPE>0</TYPE>					<MASTER_CODE>2.2.230.00.3210</MASTER_CODE>					<SOURCEINDEX>3</SOURCEINDEX>					<GL_CODE1>600.01.20.230</GL_CODE1>					<GL_CODE2>391.01.01.008</GL_CODE2>					<OHP_CODE2>100</OHP_CODE2>					<QUANTITY>3</QUANTITY>					<PRICE>2</PRICE>					<TOTAL>6</TOTAL>					<RC_XRATE>1.9888</RC_XRATE>					<DESCRIPTION>SATIŞ MAĞAZASI GELİRLERİ</DESCRIPTION>					<UNIT_CODE>KG</UNIT_CODE>					<UNIT_CONV1>3</UNIT_CONV1>					<UNIT_CONV2>3</UNIT_CONV2>					<VAT_INCLUDED>1</VAT_INCLUDED>					<VAT_RATE>8</VAT_RATE>					<VAT_AMOUNT>0.44</VAT_AMOUNT>					<VAT_BASE>5.56</VAT_BASE>					<BILLED>1</BILLED>					<TOTAL_NET>5.56</TOTAL_NET>					<DATA_REFERENCE>65536</DATA_REFERENCE>					<DISPATCH_NUMBER>0000000000000057</DISPATCH_NUMBER>					<SL_DETAILS>						<SERIAL_LOT_TRN>							<SOURCE_MT_REFERENCE>64513</SOURCE_MT_REFERENCE>							<SOURCE_SLT_REFERENCE>51983</SOURCE_SLT_REFERENCE>							<SOURCE_QUANTITY>3</SOURCE_QUANTITY>							<IOCODE>4</IOCODE>							<SOURCE_WH>3</SOURCE_WH>							<SL_TYPE>1</SL_TYPE>							<SL_CODE>3210.028.008.3.1</SL_CODE>							<MU_QUANTITY>3</MU_QUANTITY>							<UNIT_CODE>KG</UNIT_CODE>							<QUANTITY>3</QUANTITY>							<UNIT_CONV1>3</UNIT_CONV1>							<UNIT_CONV2>3</UNIT_CONV2>							<DATE_EXPIRED>30.11.2014</DATE_EXPIRED>							<DATA_REFERENCE>52702</DATA_REFERENCE>							<ORGLOGOID/>							<ORGLINKREF>0</ORGLINKREF>							<SL_NAME/>						</SERIAL_LOT_TRN>					</SL_DETAILS>

ldx_ZVLID00005383_ZVLID00007150_34_0_1_299.xml

Edited November 25, 2013 by xnanx