[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Passing form parameters to Infopath 2010 data connection sql query

Posted on 2012-08-22
1
Medium Priority
?
2,835 Views
Last Modified: 2012-08-27
I have an Infopath 2010 form.
All I need is to be able to use several form fields in the data connection query definition.
I've searched a lot but I don't find out if this is possible or not.
0
Comment
Question by:cg_ivan
1 Comment
 
LVL 28

Accepted Solution

by:
clayfox earned 2000 total points
ID: 38324570
The answer depends on what type of form you started with. If you choose a database type form then it is built to allow you to query and submit to one table or set of related tables. Any other type of form you can query, with static parameters but not dynamically. secondary data connections, except for web services cannot dynamically query.
Another gotcha in 2010 is that forms are web compatible and limited in their controls, you may need to go into form options and compatibility and change it to a filler form.

Www.infopathdev.com has tutorials and posts.
Www.qdabra.com has a packaged set of server tools that will let you do everything with multiple queries by giving you web services.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question