Code

Re: Secondary data source... PROBLEM!!!

Shiva — Tue, 17 Apr 2007 18:02:13 GMT

Hi,

You need to set the property of the ‘ALI’ secondary DOM first before you are trying to get the node list.

For that one you need to use below code.

//Get the secondary DOM
Xdocument2 secondaryDOM = (Xdocument2)XDocument.GetDOM("ALI")

//Set the property of secondary DOM
secondaryDOM.setProperty("SelectionNamespaces", “Name space of the Secondary DOM”)
Set persone = XDocument.GetDOM("ALI").selectNodes("//PERSONALE")

Re: Secondary data source... PROBLEM!!!

Greg Collins — Thu, 12 Apr 2007 17:38:06 GMT

You are not using the require namespace. There are plenty of resources available if you need to look up information about namespaces to understand them.

Basically "PERSONALE" is different than "d:PERSONALE"... that's why it can't find what you are looking for.

Secondary data source... PROBLEM!!!

checco.rossi — Thu, 12 Apr 2007 16:38:51 GMT

Hello,
i'm sorry for my terrible english...
this is my code and I don't know why return 0...The right answer is 10!!!

PERSONALE is a repeating table.
"ALI" is a secondary datasource from ACCESS DB

The first query (XDocument.DataObjects("ALI").QueryAdapter.Query) works well.


XDocument.DataObjects("ALI").QueryAdapter.Query
	
Set persone = XDocument.GetDOM("ALI").selectNodes("//PERSONALE")
XDocument.UI.Alert(persone.length)

This is ALI's structure:

myFields
__dataFields
____d:PERSONALE (repeating)
______:NR
______:COGNOME
______:NOME
______:SOCIETA
______:AREA
________AREE_REPARTO
_________:ID
_________:area
_________:reaprto
_________:note
_________:UBICAZIONE

Thanks,
Checco.