Using the XDocument.DOM in Infopath

[ikidd]

I have created a repeating section that contains a text field that is
the result of a vbScript function that calculates the difference in 2
time fields in the repeating section. I've done this because I can't
find such a function built into Infopath.

I'm using the

XDocument.DOM.selectSingleNode("/myigital_SO_Entry/my:grpTimeEntry/my:txtEntryOTBillHours").text
= intDateDiff

function to locate the text box and write the value to it.
Unfortunately, this only works for the first section, and subsequent
sections will read and write from the first set of controls only.

Is there a way to pass in the current node of the repeating section or
locate it using some property of the control that triggers the function
so I can properly locate the instance of the controls I want to read
from and write to?

If someone can even just point me to a tutorial or examples in how to
navigate the XML node structure from within Infopath scripting, I
should be able to figure it out.

I can post my code if you need to see what is happening.

TIA

 

[Ben Walters]

Hey ikidd
The problem your experiencing is due to the fact that your using a Select
single node statement

XDocument.DOM.selectSingleNode("/myigital_SO_Entry/my:grpTimeEntry/my:txtEntryOTBillHours").text = intDateDiff

The xpath expression passed in will match on the first node it finds and
return that.
What you will need to do is use the selectNodes method to return a list of
nodes then loop through that check the code provided

C#
IXMLDOMNodeList MyNodes =
e.XDocument.DOM.selectNodes("/myigital_SO_Entry/my:grpTimeEntry")

for each IXMLDOMNode BillHours in MyNodes
{
BillHours.SelectSingleNode("//my:txtEntryOTBillHours").text = intDateDiff
}

Hope this helps

Ben

 

[ikidd]

I noticed that I could pull the nodes collection, but I couldn't find a
way to determine the index of the current entry in the Entries group
that was the entry point into the script. I have to figure it is a
property of the eventobj object but I can't figure out how to use it to
determine the current node and read and write relative to that.

 

[Ben Walters]

If you need more help I would recommend getting the InfoPath SDK the help
file that comes with that has a lot of samples relative to script.

you can get the SDK her
http://www.microsoft.com/downloads/...16-93aa-4fe8-9238-d702f1bfbab4&displaylang=en

The other option is to use Managed Code (C# or VB.net) rather than script
behind your form.

Hope this helps
Cheers
Ben

 

[S.Y.M. Wong-A-Ton]

These 2 articles might help if you bear in mind that a repeating section is
basicly the same as a repeating table behind the scene:

http://enterprise-solutions.swits.n...fference-calculations-vbscript&c=infopath2003

and

http://enterprise-solutions.swits.n...value-same-row-repeating-table&c=infopath2003

 

[ikidd]

That worked great. I see the code passes the eventobj.source to the
functions, and that's the start point I needed. I also needed the DOM
handling function parentnode for the eventobj.source. I'm definitely
going to look on your site for other info.

Ben, thanks for the pointer to the SDK. I didn't want to get out of
VBscript because that complicates the deployment a fair bit, but I
definitely appreciate the help, both of you.

 

[S.Y.M. Wong-A-Ton]

No worries. Glad to help.
---
S.Y.M. Wong-A-Ton

That worked great. I see the code passes the eventobj.source to the
functions, and that's the start point I needed. I also needed the DOM
handling function parentnode for the eventobj.source. I'm definitely
going to look on your site for other info.

Ben, thanks for the pointer to the SDK. I didn't want to get out of
VBscript because that complicates the deployment a fair bit, but I
definitely appreciate the help, both of you.