Re: Filling repeating table from secondary datasource

fredarwin — Fri, 07 Jul 2006 00:54:34 GMT

Well, i have a solution.

1. First i have to work with database connections because is more easy deal with it.

2. i have to write some code:

a) setup my secodary data source (database)
var Solicitudes = XDocument.DataObjects("CatSolicitudes").DOM
Solicitudes.setProperty("SelectionNamespaces",...

b) depending of selected data, i bring items and fill with them my repeating table of my main connection:

var oFromItem = XDocument.DOM.selectSingleNode("//dfs:myFields/dfs:dataFields/d:SolicitudesMS/@idsolicitudes");
var selectedNodes=Solicitudes.selectNodes("//dfs:myFields/dfs:dataFields/d:CatSolicitudes/d:DetCatSolicitudes[@idsolicitudes='" + oFromItem.text + "']")

for (var i=0;i<selectedNodes.length;i++)
{
var row = XDocument.DOM.selectSingleNode("//d:DetSolicitudesMS");
rowClone = row.cloneNode(true);
XDocument.View.ExecuteAction("xCollection::insert",xmlToEdit="DetSolicitudesMS_18");
var xdato=selectedNodes.selectSingleNode("@Requerimiento").text;
rowClone.selectSingleNode("@Requerimiento").text = xdato;
var parent = XDocument.DOM.selectSingleNode("//d:SolicitudesMS");
parent.insertBefore(rowClone,row);
XDocument.View.ExecuteAction("xCollection::remove",xmlToEdit="DetSolicitudesMS_18");
}

this work excellent!!!

Code

Re: Filling repeating table from secondary datasource

Filling repeating table from secondary datasource