Jump to content
Sign in to follow this  
xnanx

Xml Delete Rows

Recommended Posts

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 by xnanx

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×