Deleting a row if a section inside it is empty. - InfoPath Dev
in

InfoPath Dev

Deleting a row if a section inside it is empty.

Last post 06-17-2010 02:24 PM by mgarant. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-17-2010 11:44 AM

    • Peekay
    • Not Ranked
    • Joined on 06-07-2010
    • Posts 5

    Deleting a row if a section inside it is empty.

    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 >_>

  • 06-17-2010 02:24 PM In reply to

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

    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

     

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.