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

InfoPath Dev

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

Last post 04-25-2007 12:27 PM by lordpuma. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-25-2007 10:55 AM

    • lordpuma
    • Not Ranked
      Male
    • Joined on 04-25-2007
    • Denver, CO, USA
    • Posts 2

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

    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?
    Thanks,

    lordpuma
  • 04-25-2007 11:40 AM In reply to

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

    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.

    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 04-25-2007 12:27 PM In reply to

    • lordpuma
    • Not Ranked
      Male
    • Joined on 04-25-2007
    • Denver, CO, USA
    • Posts 2

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

    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).

    Thanks,

    lordpuma
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.