submitting data from a repeating table to sql - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

submitting data from a repeating table to sql

Last post 12-26-2011 06:34 AM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 12-22-2011 10:15 AM

    • cm1818
    • Not Ranked
    • Joined on 12-19-2011
    • Posts 8

    submitting data from a repeating table to sql

    I have a an infopath form created to query a table using the GetColumnsXmlStrQuery. the query returns multiple values to a repeating table. The next part of the form is to submit the data to 2 sql tables with the repeating information going to one table and the other information going to another linked by doc_id. I can submit all the information not in the repeating table fine. I am having issues with the results the query returned to the repeating table since that doesn't appear when i am mapping fields to the database to submit information. Is this possible?

  • 12-26-2011 06:34 AM In reply to

    Re: submitting data from a repeating table to sql

    DBXL only maps the data that's in the form's main data source, but you can use qRules (in conjunction with DBXL) to either submit the secondary data to the DB using a separate doctype, or you can copy the data from the query into the main data source and then just use the DBXL mapping logic.
    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.