Copy SQL Values to InfoPath Repeating Section Fields using QueryDB - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Copy SQL Values to InfoPath Repeating Section Fields using QueryDB

Downloads: 1,421 File Size: 1.1MB
Posted By: Jo-Anne Alfafara Views: 2,282
Date Added: 09-10-2010

Want to copy values from your SQL table to your InfoPath form’s repeating section without code? qRules already comes with a CopyTable command. This command works well but has one big drawback: it requires that your InfoPath form’s repeating table has the same number of fields as your SQL table, and may also require the same data types. This can cause problems when the database table has columns without values or when your form has a different structure. What to do?

You can use the QueryDB web service to query your database and the qRules Insert command to add the fields. The Insert command and other rules to set values are set up in a rules loop. To stop the loop, you’ll have to add a Count field to your form that you decrement as you walk through your secondary data source setting values into your main data source, but it’s relatively easy to do.

This technique can be used for a variety of scenarios where you would like to copy repeating data from a secondary data source to your main data source and the structures don’t match.

This tutorial shows you how to set it up. Included is a sample that you can download, design and review if you don’t have time to build your own.


Filed under: ,


No comments exist for this file.
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.