SQL Query with repeating table - InfoPath Dev

InfoPath Dev

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

SQL Query with repeating table

Last post 03-16-2018 08:12 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-13-2018 06:54 AM

    SQL Query with repeating table

    I tried searching for this topic, but couldnt find anything that I could use. I have an Infopath 2013 form, which pulls some vendor name and number info from a sql server (about 65000 records). I originally had this connection automatically connecting, but because of the size of the database - I am doing a manual query. So I have a field - VendorSearch, on each line of the repeating table, where user will enter a vendor name. The search will look up records in the SQL DB - and give a pull down list. The first line works perfectly. Problem happens when I add a new line - the query is stuck on the first search. I would like to requery the data for the new info user will need.
  • 03-16-2018 08:12 AM In reply to

    Re: SQL Query with repeating table

    So - the VendorSearch field is inside the repeating group? And the rule is on VendorSearch? Attach your form under the Options tab in a reply if you'd like me to take a quick look.
    Hilary Stoupa

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