Re: Updating the query in dataconnection with value from form field

Patrick Halstead — Wed, 08 May 2013 06:49:24 GMT

How to query form data from SQL?

- Configure “out-of-box” data connection
    o Can’t filter the data – pulls down entire table or fixed subset
    o Browser forms have limited amount of data due to IPFS resource limits
- Write code
    o Won’t run in browser
    o Tightly coupled to schema – greater maintenance cost, requires visual studio
- Inject Qdabra's qRules plugin
    o Sandbox / site collection admin – extra site configuration
- Write Web service
    o Each query shape requires different Web service – greater maintenance cost
- Qdabra generic DBXL Web service (QueryDB Web method)
    o No coding required
    o Data-driven design – dynamically recreate queries on fly
    o One Web service for all DB queries – low cost solution

Updating the query in dataconnection with value from form field

JeetS — Tue, 30 Apr 2013 13:52:31 GMT

Hello there,

A quick background, I have a browser enabled form template created in infopath for MOSS 2007, I have data connection created which queries for data from sql server, what I am trying to do is that when one of the form filed value is entered, that data should be part of my query condition in data connection, is there way to do this without code, Any help sooner is greatly appreciated.

JeetS

Data Connections

Re: Updating the query in dataconnection with value from form field

Updating the query in dataconnection with value from form field