Code

Re: Copy LAST row of repeating table?

jaxkookie — Mon, 19 Sep 2011 16:01:26 GMT

I was looking for a similar solution for 2010, with nested repeating tables. I tried both solutions and this one was a homerun. thanks

Re: Copy LAST row of repeating table?

kcoakley — Wed, 10 Feb 2010 20:27:37 GMT

Jimmy - thanks again for your help. Your IP 2007 code worked like a charm as soon as I realized that my repeating table must be the last node in my "parent" node.

Thanks again,
Ken

Re: Copy LAST row of repeating table?

Jimmy — Wed, 10 Feb 2010 02:05:50 GMT

kcoakley:
What are the offending items in this code?

Every single one of them, I'm afraid :-)

The corresponding code for IP 2007 would be:

XPathNavigator row = MainDataSource.CreateNavigator().SelectSingleNode("//my:repeatingtable[last()]", NamespaceManager);
// I don't think you need the value getting and setting code,
// since the values are already in the row being copied

XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields", NamespaceManager);

parent.AppendChild(row);

Re: Copy LAST row of repeating table?

kcoakley — Tue, 09 Feb 2010 22:18:27 GMT

Thank you both for your replies - I really appreciate it! Jimmy's suggestion worked perfectly and now the button is behaving exactly as I had hoped.

One last question, if I might... I'm using InfoPath 2007 but this code requires C# with InfoPath 2003 compatibility to run correctly. What are the offending items in this code?

Thanks again,
Ken

Re: Copy LAST row of repeating table?

Qazi Anis — Tue, 09 Feb 2010 05:01:06 GMT

try this

            XPathNodeIterator listItemNav = this.MainDataSource.CreateNavigator().Select("my:myFields/my:group1/my:group2", this.NamespaceManager);
            for (int i = 0; i < listItemNav.Count; i++, listItemNav.MoveNext()) ;
            listItemNav.Current.Clone().InsertAfter(listItemNav.Current);

Re: Copy LAST row of repeating table?

Jimmy — Tue, 09 Feb 2010 02:42:43 GMT

What happens if you use "//my:repeatingtable[last()]" in that first line?

Copy LAST row of repeating table?

kcoakley — Mon, 08 Feb 2010 17:47:22 GMT

Hello and thank you for such a wonderful resource!

I've cobbled together some code found here that copies the first row of a repeating table and appends it to the bottom of the repeating table when I click a button. The code looks like this:

-----
IXMLDOMNode row = thisXDocument.DOM.selectSingleNode("//my:repeatingtable");

string field1 = row.selectSingleNode("my:field1").text;
string field2 = row.selectSingleNode("my:field2").text;
string field3 = row.selectSingleNode("my:field3").text;

row = row.cloneNode(true);

row.selectSingleNode("my:field1").text = field1;
row.selectSingleNode("my:field2").text = field2;
row.selectSingleNode("my:field3").text = field3;

IXMLDOMNode parent = thisXDocument.DOM.selectSingleNode("/my:myFields");

parent.appendChild(row);
-----

Is there a simple way to modify this code so that the LAST row of the repeating table is copied?

Thank you,
Ken