Code

Re: Fill a queryField from another file

gregv — Mon, 29 May 2006 06:07:26 GMT

Sorry for my late answer but I was on hollidays for 4 days.
So I tried this morning your solution Abhishek and it works.
Thank you for your help :)

Re: Fill a queryField from another file

Abhishek — Thu, 25 May 2006 05:06:52 GMT

Hi gregv,
On the click of a button(in a row ) of a repeating table, if u need to access the value of a control in the same row, then u need to use
n1=eventObj.Source.selectSingleNode("<Field name>");

Note that <FieldName> is not the whole XPath of that field,but just the particular field's name only.

Just check out the following link
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=1986&SearchTerms=e.Source

Regards,
Abhishek

Re: Fill a queryField from another file

gregv — Wed, 24 May 2006 15:36:32 GMT

Thanks, it works.
But I found another problem, the value contained in n1.text is always the same, even if I click on different lines. Do I have to specify something else in the first selectSingleNode to precise to use the current line ?

Re: Fill a queryField from another file

Matt Faus — Wed, 24 May 2006 15:24:27 GMT

You will have to tell the node about the namespace that you are using, try this immediatly after NewFromSolution():

xd.setProperty("SelectionNamespaces", 'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" ' );

Fill a queryField from another file

gregv — Wed, 24 May 2006 13:35:14 GMT

Hello
I've got an extensible table wich has on each line a button.
This button has to open another infopath file and make a query depending on the line it was activated.
The files are both linked to a SQLserver database. Here is the code put on the button :

function CTRL63_7::OnClick(eventObj)
{
	var n1 = null;
	n1 = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:co_refdevis/@do_id");
	
	var xd = null;
	xd = Application.XDocuments.NewFromSolution("V:\\...\\FileToOpen.xsn");
	
	var n2 = null;
	n2 = xd.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:co_dossiers/@do_id");
	
	n2.text = n1.text;
	xd.Query();
}

When I click on a button, it opens the file correctly but throws an error (translated from french) : Reference to non-declared prefix space : dfs
In debug, the error occurs on the line n2 = xd.DOM.selectSingleNode(...);

I don't understand because the two files are both based on SQLserver and dfs appears in both when i use formula.
Do someone knows what causes this error please ?

Thanks in advance.