InfoPath Dev

IP2007 

Just started working with webservices created from SQL2005 SOAP Endpoint creation...which pulls data nicely onto the form...problem is trying to read a field value of the repreating table...I do this all the time with database connected fileds, but can't seem to get the syntax right...or it's a namespace issue...

I get the following error (  Reference to undeclared namespace prefix: 'dfs'. ) when executing this code

XDocument.UI.Alert(eventObj.Source.selectSingleNode("/dfs:myFields/dfs:dataFields/s0:GetSCMAAccountsResponse/s0:GetSCMAAccountsResult/ns1:SqlRowSet1/ns1:row1/ns1:scmaaccount").text);

 I'm not specifying the array index of the repeating table, but should'nt it pull the first one anyway?

here is the xpath for the field I want : "/dfs:myFields/dfs:dataFields/s0:GetSCMAAccountsResponse/s0:GetSCMAAccountsResult/ns1:SqlRowSet1/ns1:row1/ns1:scmaaccount"

here is the namespace declarations: XDocument.DOM.setProperty("SelectionNamespaces", '
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields"
xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"
xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"
xmlns:xdado="http://schemas.microsoft.com/office/infopath/2003/adomapping"
xmlns:s0="http://tempuri.org"
xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes"
xmlns:sqlsoaptypes="http://schemas.microsoft.com/sqlserver/2004/SOAP/types" xmlns:sqlresultstream="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream" xmlns:sqlmessage="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage" xmlns:sqlrowcount="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount" xmlns:sqltransaction="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction" xmlns:_xdns0="http://schemas.microsoft.com/office/infopath/2003/changeTracking"
xmlns:ns1="urn:schemas-microsoft-com:sql:SqlRowSet1"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sql="http://schemas.microsoft.com/sqlserver/2004/SOAP"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-08-14T17:04:14"
xmlns:xd="http://schemas.microsoft.com/office/infopath/2003"');

OK..I htink it has somethin gto do with the repeating table being on a different view...I have a seperate view to display several fields and want the user to pick a row from which I will popluate a few fields on the main view...I copied a button that displayed some chicken tracks from the main view to the second view and got the same nastygram about undeclared namespaces....????

OK...bad code at first post...forgot to mention it is a 2dairy ds ... here is the code:

function btnSelectSCMAAccount::OnClick(eventObj) {
// Write your code here

// Get the DOM for the Seconday Data Source
var dat = XDocument.DataObjects("GetSCMAAccounts").DOM;
dat.setProperty("SelectionNamespaces", 'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:s0="http://tempuri.org" xmlns:ns1="urn:schemas-microsoft-com:sql:SqlRowSet1" ');

var xpath = "/dfs:myFields/dfs:dataFields/s0:GetSCMAAccountsResponse/s0:GetSCMAAccountsResult/ns1:SqlRowSet1/ns1:row1/ns1:scmaaccount";
var wVar = XDocument.DOM.selectSingleNode(xpath).text;
XDocument.UI.Alert("SCMA Account = " + wVar);

}

I get an "object required" message for the statement var wVar = XDocument.DOM.selectSingleNode(xpath).text;

strange...this code works perfectly when the webservice is used as the main data connection (rcv only)

var xpath = "/dfs:myFields/dfs:dataFields/s0:GetSCMAAccountsResponse/s0:GetSCMAAccountsResult/ns1:SqlRowSet1/ns1:row1/ns1:scmaaccount";
var wVar = XDocument.DOM.selectSingleNode(xpath).text;
XDocument.UI.Alert("SCMA Account = " + wVar);

so...it has to be something to do with the namespace??? dfs is declared...s0 is declared...ns1 is declared...???

da huh...might help if I had pulled from the secondary DOM...

var wVar = XDocument.GetDOM("GetSCMAAccounts").selectSingleNode(xpath).text;

 

been a while since I last used IP...