Newbie Questions

Re: Access to an Access DB #2

Jerry — Thu, 04 May 2006 13:48:17 GMT

Sorry Matt.... since I'm new to Infopath and XML, I have no idea as to what I'm looking for by using the alert functions you suggested in your last reply. I checked, double and triple checked the steps of your tutorial, but it does not work. I still get the error message
"Object required". Referring to the link below... regarding populating fields from a drop-down selection...this is what I want to do, but in this reference the data to be populated is in the XML code, not a DB. I do not want to have to key the data into the XML code, instead I want to pull it out of the DB. In the example below, what would I have to change to access the database?

http://infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85

Re: Access to an Access DB #2

Matt Faus — Tue, 02 May 2006 14:11:12 GMT

This could mean only one thing: That your XPath is failing in the selectSingleNode() function.

Here are some tips for debugging the XPath, all of these can be examined via Alert()
eventObj.Source.nodeName
eventObj.Source.nodeType
eventObj.Source.parentNode.nodeName
eventObj.Site.nodeName

Also, be sure to look at the context of the button to make sure that the XPath is appropriate. I hope this helps, let us know if there are any more problems!

Re: Access to an Access DB #2

Jerry — Tue, 02 May 2006 13:58:28 GMT

Hi Matt.... I'm just trying to execute your tutorial exactly. I made the code modification as you suggested, but am still getting the error. Line 27.... Object Required. Below is line 27 of the code..

XDocument.UI.Alert( eventObj.Source.selectSingleNode("@CustomerID").text );

Re: Access to an Access DB #2

Matt Faus — Tue, 02 May 2006 01:46:33 GMT

Are you trying to recreate the form from the tutorial? If you followed the steps exactly, the code should work (I still have my XSN that I made for that HowTo if you want it). Or are you trying to apply the HowTo to your own situation?

Either way, it sounds like you are getting an XPath error so that selectSingleNode returns a null object. As a quick test update your code for the following and tell me where the error occurs:

// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of arguments.
//=======
function btnViewDetail::OnClick(eventObj)
{
var oQueryId = XDocument.DOM.selectSingleNode
("/dfs:myFields/dfs:queryFields/q:Customers/@CustomerID" );
XDocument.UI.Alert( oQueryId.text );
XDocument.UI.Alert( eventObj.Source.selectSingleNode("@CustomerID").text );
oQueryId.text = eventObj.Source.selectSingleNode("@CustomerID").text;
XDocument.Query();
XDocument.View.SwitchView("Detail");
}

Access to an Access DB #2

Jerry — Mon, 01 May 2006 21:17:41 GMT

My original question was about how to read an Access database and pull data from it and insert the data into specific fields in the InfoPath form. Matt Faus, gave me the following link, and I was able to follow the instructions; however, something appears to be wrong with the code for the 'Button' called View Details.

http://infopathdev.com/howto/tutorials/default.aspx?i=0bb37b4de44348408680a53a449f2353

I get an error message which says... "Object required". There must be something wrong with the code? Line 24... where it starts out as "oQueryID.text = eventObj.Source.selectSingleNode...

// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of arguments.
//=======
function btnViewDetail::OnClick(eventObj){var oQueryId = XDocument.DOM.selectSingleNode
("/dfs:myFields/dfs:queryFields/q:Customers/@CustomerID" );
oQueryId.text = eventObj.Source.selectSingleNode("@CustomerID").text;
XDocument.Query();
XDocument.View.SwitchView("Detail");}

What am I doing wrong?