Query an SQL Secondary Data Source - InfoPath Dev
in

InfoPath Dev

Query an SQL Secondary Data Source

Last post 01-11-2007 10:04 AM by Matt Faus. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 01-11-2007 08:29 AM

    Query an SQL Secondary Data Source

    Is there any way to query an SQL Data Source using a parameter via a text box, similar to the Main Data Source?

    I'm limited to querying all records only from the secondary source.

    Any thoughts?
  • 01-11-2007 10:04 AM In reply to

    Re: Query an SQL Secondary Data Source

    Hi Javier,

    I'm not sure exactly what you mean, but there are a couple of ways to query SQL data sources. The fields provided in the queryFields group generated by InfoPath can take values that will filter the results returned, or you can use code to edit the raw SQL statement that is sent.
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.