-
What I mean is that when a SQL statement is written in other tools, such as Access or SQL Server, double quotes are not put around each part of the statement i.e., I'm used to seeing dbo.jobmaster without any quotes at all.
-
My form contain Data Connection to a web service that return values of specific column in my sql server data case table.
I use this Data connection for set values for Drop Down list in my form.
When I open the form i get this error
''
The following DataObject either cannot be created or cannot be initialized: SelectAreaCodesPhone
The query ...
-
-
Hello and welcome to the InfoPathDev.com forums! For questions about InfoPath, you have come to the right place. Several of the admins on this forum were a part of the team that built the InfoPath application in it's earliest days. InfoPathDev.com exists as a grassroots site so that developers around the world can discuss issues and ...
-
You've got the object, but now you've got to get the content, try this:
XDocument.UI.Alert(''au_fname: '' + objDOMNode.text);
-
This does seem a little weird, check out this HowTo:http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85
-
What do you mean that double quotes are not proper syntax? IP uses Jet SQL to interact with the SQL server. Can you paste the query you're trying to get working?
-
You might also check out this HowTo:http://www.infopathdev.com/howto/tutorials/default.aspx?i=3b9d4d677daf4ef18d8e93d0cd188194
-
You should be using a database query filter, not a InfoPath data filter. To filter in the query string, check out this HowTo:http://www.infopathdev.com/howto/tutorials/default.aspx?i=0bb37b4de44348408680a53a449f2353 or this post:http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2561
As I've been working on and using the EnumDB web service I ...
-
Actually, if your form's main DOM is the database connection, you can issue queries against it through the ''queryFields'' group.
However, when trying to make a secondary data connection to a DB you can't accomplish this in the IP designer, but you can through the use of code. Just add a regular database connection, and then write a little code ...