Code

Re: Adding first row to repeating table

BhailDa — Fri, 06 Oct 2006 16:39:12 GMT

I has a simialr problem within InfoPath 2007 Managed code. Code solution:

// Now Create a new row
// Find first Instance of repeat nodes and create entry before.
xNode = xNavigator.SelectSingleNode("//History", this.NamespaceManager);
string sNewRow = string.Format("<History><User>{0}</User><ChangeType>{1}</ChangeType><CreateDate>{2}</CreateDate></History>", sUser, sChangeType, sCreateDate);
xNode.InsertBefore(sNewRow);

Re: Adding first row to repeating table

LaurieAPMarsh — Tue, 03 Oct 2006 16:19:36 GMT

In fact last night I got your first option working and this morning your second option. It still seems like creating the node should work but I sure don't see the mistake.

Thank you for your reply.

Re: Adding first row to repeating table

Matt Faus — Tue, 03 Oct 2006 16:14:55 GMT

I think the problem with appendChild is that you are making some kind of mistake when you call thisXDocument.DOM.createNode(). There might be some kind of problem with the namespace or something, but this should work if everything is done correctly.

However, there are a couple of ways to solve this problem:

1. Create a global IXMLDOMNode variable to hold the clone of the QF129 node, and populate this variable in Onload. This way you will have the clone before it is removed and you will have it for the life of the code since it is a global variable.

2. Create a temporary DOM and load the xml from the template.xml file.

Personally, I think the first method is cleaner and easier.

I hope this helps - good luck!

Adding first row to repeating table

LaurieAPMarsh — Mon, 02 Oct 2006 14:23:05 GMT

I have a main connection that looks like:

myFields
  dataFields
    d:COE_Employees
      -- some stuff --
      Comments
        -- some attributes --
      QF129
        -- some attributes--

both Comments and QF129 are repeating. Here is the template.xml view:

<dfs:dataFields>
    <d:COE_Employees EmployeeKey="" Name="">
-- other stuff --
       <d:Comments CommentKey="" Engineer="" Date=""  
                   Comment=""></d:Comments>
       <d:QF129 Employee="" Date=""></d:QF129>
    </d:COE_Employees>
</dfs:dataFields>

After the query is issued, there are no QF129 items in the DOM. During the lifetime of the form, I want to add them programmatically but cannot use the cloning method since there aren't any to clone from. Here is the code I have to create the new node and add it to the DOM:

IXMLDOMNode rootNode = thisXDocument.DOM.selectSingleNode
                   ("/dfs:myFields/dfs:dataFields/d:COE_Employees");
IXMLDOMNode QF129Node = thisXDocument.DOM.createNode(
                 DOMNodeType.NODE_ELEMENT, "d:QF129",
 "http://schemas.microsoft.com/office/infopath/2003/ado/datafields");
IXMLDOMAttribute attr = thisXDocument.DOM.createAttribute
                                         ("Employee");
attr.value = rootNode.selectSingleNode("@EmployeeKey").text;
QF129Node.attributes.setNamedItem(attr);
attr = thisXDocument.DOM.createAttribute("Date");
attr.value = thisXDocument.DOM.selectSingleNode
                               ("/dfs:myFields/my:WeekEnding").text;
QF129Node.attributes.setNamedItem(attr);
rootNode.appendChild(QF129Node);

The problem is that the call to appendChild fails with an error saying:

Element 'http://schemas.microsoft.com/office/infopath/2003/ado/datafields}QF129' is unexpected according to content model of parent element 'http://schemas.microsoft.com/office/infopath/2003/ado/dataFields}COE_Employees'.

So, how do I add the first item for a repeating element programmatically?