-
Hi SC and welcome!
Short answer: right click on your tables select table properties and make sure the cell padding is set to 0.
Longer answer ...
InfoPath uses XML which is great for the following reasons:Structured data that can be searchedClient side validation using XML data schema, restrictions and other constraintsSupports Web services ...
-
If you are in IP 2007, getting the XPath is easy - right click the node in the task pane and select Copy XPath.
Now, you will only need the XPath from listData to LooseCartons, based on your original post, but copying the XPath and pasting into a text editor will at least show you the correct namespace for your node.
-
It's a secondary data source and it's InfoPath 2007.
-
Is this in your main data source? Or a 2DS? I'm guessing you are using InfoPath 2003 - is that correct?
-
I was wondering the same thing about the prefix so I tried using some that match those on the data source to no avail and I've also tried it with only "LooseCartons". Also, the eventObj.Site.xml did now show a prefix in any of the xml nodes. I'm not sure if that matters, though. Aside from the data sources in the InfoPath Design, ...
-
The DBXL web service uses standard SOAP protocol. It can be called from any application that supports calling SOAP based services.
It appears that SAS can call web services, but we do not have any documents specific to calling from other applications.
-
Hi,
Exact is a valid option for searchType, though there may be something else going on that's causing searchType to be reset to blank (per the error message).
Could you attach the form template (via the Options tab) so we may take a look?
Thanks.
-
My guess would be that t is null because your XPath is incorrect. I'd try just "LooseCartons" like in your original post - but is there a namespace prefix on that XML? You may be missing that....
-
Using the QdabraAD
I am creating a new form where I have a name box and need to generate the email of the name into another field. I have done this on multiple forms before so not sure why this error:
The query cannot be run for the following DataObject: FindUsersByName
InfoPath cannot run the specified query.
The SOAP response indicates ...
-
Yeah, that's embarrassing. Thanks.
I've fixed that but now I'm getting another error "Object required" on Alert line below:
var t = eventObj.Site.selectSingleNode("/listdata/LooseCartons");
XDocument.UI.Alert("TEXT: " + t.text); // Error happens here.