Data Connections

Re: Repeating Expression Box from Secondary DS in Main DS Repeating Table

Greg Collins — Tue, 05 Jun 2007 20:09:48 GMT

Great! Glad to have been of some assistance.

Re: Repeating Expression Box from Secondary DS in Main DS Repeating Table

Iurii.Sas — Tue, 05 Jun 2007 12:23:58 GMT

Thanks, Greg!!!

It was very useful.

Re: Repeating Expression Box from Secondary DS in Main DS Repeating Table

Greg Collins — Mon, 04 Jun 2007 16:38:16 GMT

Do a little research on the XPath function: current()

This will help you accomplish what you want to do. Your XPath above would be something like (not necessarily exactly like):

xdXDocument:GetDOM("v1")/dfs:myFields/dfs:dataFields/d:v1/@Value[../@ID = current()/@ID]

Hope this helps.

Re: Repeating Expression Box from Secondary DS in Main DS Repeating Table

Iurii.Sas — Thu, 31 May 2007 06:59:38 GMT

Greg, thank for advise.

But I don't know how I can take current row ID in t1.

I used such expression:

xdXDocument:GetDOM("v1")/dfs:myFields/dfs:dataFields/d:v1/@Value[../@ID = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/d:t1/@ID]

But this expression box displays value from v1 that matches with first ID in t1 for all rows.

What do I wrong?

Re: Repeating Expression Box from Secondary DS in Main DS Repeating Table

Greg Collins — Wed, 30 May 2007 16:36:20 GMT

You will need to use filters on v1 field to make sure they key correctly to the current row.

i.e. you would place your expression box in the table row, and then add a filter to the expression box such that the v1 key matches the key of the current row.

Repeating Expression Box from Secondary DS in Main DS Repeating Table

Iurii.Sas — Wed, 30 May 2007 15:50:32 GMT

Hi!
Help please!
I'm developing InfoPath form for editing data in MS SQL Server 2005
DB (directly connected).

I have table (t1) with data and view (v1) which calculates special
values for each row of table (t1).

I want to display in repeating InfoPath table data from t1 and
corresponding values for each row from v1 with ability to edit data in
t1. t1 and v1 link through t1 Primary Key.

When I select data from t1 and v1 in other SQL view and set it as Main
data source in InfoPath I can't submit data in t1.

When I set t1 as Main data source I can't attach data from v1
(Secondary data source) to each row in repeating table. Field from v1
displays value only from first row of v1, but not changes it for each
row.