Passing form parameters to Infopath 2010 data connection sql query

Posted on 2012-08-22
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.
Question by:cg_ivan
    1 Comment
    LVL 28

    Accepted Solution

    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. has tutorials and posts. has a packaged set of server tools that will let you do everything with multiple queries by giving you web services.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This video discusses moving either the default database or any database to a new volume.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now