General

Re: Reading specific row in a Repeating Table

jjanicik — Thu, 01 Sep 2005 12:08:48 GMT

Thanks to all who helped. I finally got it working. I used this

e.Source.selectSingleNode("@ID").text

rather than this

e.Source.selectSingleNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text

Thanks again.

Re: Reading specific row in a Repeating Table

vt_asparagus — Wed, 31 Aug 2005 19:04:11 GMT

That "e" object reference would only work if the code was placed inside of an event handler. That may or may not be what you need. The author did not specify which event in the Repeating Table would be used.

If you have a button on your form that will open another form I think that the code I referenced above may be what you need. You could write something like:

Dim iCurrentIndex = GetCurrenntFooIndex()
If iCurrentIndex <> -1 Then
XDocument.DOM.selectNode("//my:Foo")(iCurrentIndex)
End If

Re: Reading specific row in a Repeating Table

jjanicik — Wed, 31 Aug 2005 16:55:09 GMT

Thanks for the suggestions.

One question from a newbie:

How do I declare the object "e" in the following code that you suggested:

e.Source.selectSingleNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text

I tried using eventobj instead of e and that did not work either.

Thanks for your help.

Re: Reading specific row in a Repeating Table

Coita Thierry — Wed, 31 Aug 2005 13:00:42 GMT

Hi,

try (sorry it's in c#):

string param = e.Source.selectSingleNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text

++

Thierry

Every moment hesitated is a moment gone for life!!! Think about it

Re: Reading specific row in a Repeating Table

vt_asparagus — Wed, 31 Aug 2005 12:55:34 GMT

You can do the following. It is in VBScript, in JScript you would call parseInt(...) instead of CInt(...)

Function GetCurrenntFooIndex
GetCurrenntFooIndex = CInt(XDocument.GetNamedNodeProperty(XDocument.DOM.selectSingleNode("//my:Foo"), "CTRL656", -1))
End Function

You will need to extract all of your files from the XSN and go into the view. Then search for xdRepeatingTable and find the xd:CtrlId.

Note that -1 will be returned if there is any error. Suggest putting it into a constant.

Finally I have only been able to get this code to work if I go to the Repeating Table property window, click on the Master/Detail tab, and select the Set as Master option, even though the table is not a master/child table. Can anyone explain that?

Reading specific row in a Repeating Table

jjanicik — Wed, 31 Aug 2005 12:24:01 GMT

I am looking for syntax to read a field value from a row that the user clicks on a button or hyperlink in a repeating table.

The intent of this is to pass the specific id field value for that row to another form that is being opened and populated.

My current attempt to read the field value is:

var param1=XDocument.DOM.currentNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text;

The problem is that this retrieves the id field value for the first row in the repeating table, rather than for the row that was clicked on.

Any ideas to make this work would be sincerely appreciated.

Jim