InfoPath Dev

Hello,

I use SQL code to fill in secondary connection fields. I get the values and I submit the form via Email. When receiver opens the form, they can see but empty fields. Where have these values from secondary connection disappeared? Do these secondary connections refresh automatically at some point? What is the best practice to get values remaining?

I don't have automatic retrieval of dta in this connection on form opening. I have a database form.

If I understand your issue correctly this is happening because you are not storing the values from the secondary data source in the main data source.  Data you retrivew with the secondary data source (2DS) is not kept in the form so typically people will get data with the 2DS and then copy what they need into the main data source.  Once it's in the main data source the data is in the XML file associated with that form.

Also, it sounds like you have a SQL bound form which can be tricky to work with.  We typically suggest people don't use SQL bound forms because it makes modifying your form harder as you need to modify your DB first and then make the changes in the form. 

Patrick has a blog about gaps when using SQL bound forms, it is at the bottom of this link here: http://www.infopathdev.com/blogs/patrick/archive/2010/01/29/infopath-gaps-in-sharepoint-and-sql.aspx

We suggest working with a web service like DBXL (http://www.qdabra.com/en/products/DBXL.aspx) when working with SQL.  It really can make things much easier to manage and maintain in the long run. 

Ted

Hi,

Yes secondary data source is only for guiding user who is filling the form, nothing is actually saved to main connection.

I circled around this problem with OnLoad function in SQL code, probably best way to handle it without web services.