Re: Deleting a row if a section inside it is empty.

mgarant — Thu, 17 Jun 2010 21:24:18 GMT

Hello Peekay!

Here is a link that will help you out to iterate on your repeating table (step 6)

http://www.bizsupportonline.net/infopath2007/how-to-submit-items-rows-repeating-table-infopath-sharepoint-list.htm

Deleting a row if a section inside it is empty.

Peekay — Thu, 17 Jun 2010 18:44:50 GMT

Hi!

Currently, I have an Infopath form linked to an Access Database.

Through a query, I populate a Repeating table.

Each row have an Extended Section inside of it which is a relationship in Access.

What happens is the query will show a row even though the Extended Section is empty.

My goal is rather simple, delete the Row is the Extended Section is empty.

Here's what I Have right now:

   public void Equipement_Changed(object sender, XmlEventArgs e)
        {
            XPathNavigator domNav = MainDataSource.CreateNavigator();
            XPathNodeIterator rows = domNav.Select(
            "/dfs:myFields/dfs:dataFields/d:Equipement", NamespaceManager);

while (rows.MoveNext())
{

}

I know I need to get the extended Section's Node and check if it's null for each row, and delete the row if it's indeed true.
Infopath's Nodes/XPath has me rather confused and Could use a little help to point me in the right direction >_>

Code

Re: Deleting a row if a section inside it is empty.

Deleting a row if a section inside it is empty.