SQL Database Integration

Re: Is it possible for InfoPath to select a specific row from a database?

lordpuma — Wed, 25 Apr 2007 19:27:54 GMT

Thank you! I will see if that works.

What is the EnumDB web service, though? I can find references to it in the forums, but nothing explicitly saying what it is or where to get it. (Which probably means I'm just looking right past it).

Re: Is it possible for InfoPath to select a specific row from a database?

Matt Faus — Wed, 25 Apr 2007 18:40:12 GMT

Hi lordpuma and welcome to the forums!

Check out this blog post to see how to setup a query filter to return a certain subset of rows from a database: http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-a-Query-Filter.aspx

We also have this EnumDB web service that will allow you to do this.

Is it possible for InfoPath to select a specific row from a database?

lordpuma — Wed, 25 Apr 2007 17:55:55 GMT

I'm wondering if it is possible for an InfoPath form to select a specific row 
or cell from a SQL database.  It seems that I can populate a drop-down list 
with a column from a database, but not a row.

Basically, I have a database with Employee stats for a call center. These 
stats are things like number of calls per hour and average length of a call.  
I'm creating a Monthly Coaching form in InfoPath, and I want it to 
automatically pull an employee's stats when their name is selected from the 
list.

So I need a way to code it so that the form says, "Okay, so John Smith's 
login is 1234, so I need to pull the row from the database that starts with a 
cell containing 1234, and populate a field with the information in the third 
cell for that row, which is his average call time for the month of May."

Is that possible with InfoPath, or am I asking too much?