General

Re: Delete Empty Row in a Repeating Table

Jean-Francois — Fri, 19 Apr 2013 21:09:33 GMT

I've tried to use the code above but am still getting many errrors. Can you help through this? I want this as a validating code to essentially delete any records where my repeating table brandcode and brandalloc fields are empty.

Public Sub tblbrandalloc_Validating(ByVal sender As Object, ByVal e As XmlValidatingEventArgs)

' Write your code here.

var objXMLNode;

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:tblfrmid/d:tblCouponMaster/d:tblbrandalloc[d:brandcode="" and d:brandalloc=""]");

objXMLNode.removeAll();

End Sub

Re: Delete Empty Row in a Repeating Table

Tome — Wed, 25 Apr 2007 21:52:52 GMT

Done!!

Thanks for all the help guys. I thought I had tried it already, but the code below worked like a champ.

var objXMLNode;
objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[@empID = '']");
objXMLNode.removeAll();

Re: Delete Empty Row in a Repeating Table

Shiva — Wed, 25 Apr 2007 19:03:02 GMT

Hi Tome,

You are using // to starting of your XPath may be that is one thing it goes to wrong. You can use only / to the starting of your XPath. You need to verify if d prefix is required or not for 'Service_Receipts' and 'SR_Employees' node. Check once again your XPath.

Re: Delete Empty Row in a Repeating Table

madhuri — Wed, 25 Apr 2007 07:17:22 GMT

i think prefix is missing for an 'empID'. If the 'EmpID is an element then you should add 'd:' ,if it is an attribute then you should add ' @ ' .

if empID is an element then the code should be

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[d:empID = '']");

if the empID is an attribute then the code should be

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[@empID = '']");

Re: Delete Empty Row in a Repeating Table

Tome — Tue, 24 Apr 2007 23:41:19 GMT

Great..

var objXMLNode;
objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees");
objXMLNode.removeAll();

Thanks for the code. I've started adapting it to my form. I can delete all records in the Employees section using the code above. But when I modify the selectNodes line to select records with no employees (code below) nothing happens. Not sure what exactly im doing wrong with it.

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[empID = '']");

Re: Delete Empty Row in a Repeating Table

Shiva — Sun, 22 Apr 2007 05:39:49 GMT

Hi,

You need to remove the empry rows before submitting the sharepoint or database then you need to write the following code to remove those empty rows.

//This statement gives the whichever you have all empty rows in repeating section.

IXMLDOMSelection emptyRows = (IXMLDOMSelection)thisXDocument.DOM.selectNodes("..\..\my:RepeatingSectionNodeName[my:field1 = '' and my:field2 = '']");

//This statement removes the all rows which are empty ones

emptyRows.removeAll();

Re: Delete Empty Row in a Repeating Table

ahardin — Fri, 20 Apr 2007 14:50:21 GMT

Welcome to the forums.

First off this would have to be done in code run before the submit but it is altogether easier to allow users to delete lines and use valuidation to prevent submission until the line is deleted.

You could also have a rule that sets another field called CHECK on the end of your row that is invisible to the user that says if the frist row and first column is not blank then set the CHECK field to OK, then use conditional formatting to prevent users from adding to or deleting the control unless all instances of CHECK are not equal to OK.

I hope this helps

Adam

Delete Empty Row in a Repeating Table

Tome — Thu, 19 Apr 2007 19:42:18 GMT

What I am attempting to do is write jscript to determine if there is a blank row in one of my repeating tables. I removed the ability for users to delete rows but I need to remove blank ones just before I submit to sharepoint and the database. Any hints in regards to how I could do this, would be great.