SQL Database Integration

Re: InfoPath Form to Submit data to multiple rows in SQL table

gec13 — Tue, 25 Mar 2014 16:31:01 GMT

Hi Hilary

Many thanks for your guidance, much appreciated.

Cheers

Re: InfoPath Form to Submit data to multiple rows in SQL table

Hilary Stoupa — Tue, 25 Mar 2014 16:13:42 GMT

Sorry to be slow getting back to you - what you want to do is going to require code. I guess I'd create the form bound to the DB table I want to submit to, then on form open or click of a button or whatever makes sense for your particular process, you'll need to use code to insert rows into the main data source (as many are present in your secondary data connection to your other table) and populate values.

Re: InfoPath Form to Submit data to multiple rows in SQL table

gec13 — Tue, 25 Mar 2014 09:23:17 GMT

Hi Hilary

I would be grateful, if you could advise that the above is possible using InfoPath or not?

I am familiar to Vb Script, if it is achievable via scripting behind controls.

Cheers

gec13

Re: InfoPath Form to Submit data to multiple rows in SQL table

gec13 — Mon, 24 Mar 2014 11:01:19 GMT

These rows to be added automatically (without user clicking INSERT) into the form and then submit the information to database when the form is submitted.

Re: InfoPath Form to Submit data to multiple rows in SQL table

gec13 — Mon, 24 Mar 2014 10:57:39 GMT

Hi Hilary

Many thanks for your help.

I have attached the screenshot of my aims, I would like to achieve this using one component.

I did designed the forms previously which queries from one database, display data in text box and then submits to the other but they were submitting to different columns in one row.

Now the goal is to submit data into multiple rows??

Any guidance will be much appreciated.

Thanks

Re: InfoPath Form to Submit data to multiple rows in SQL table

Hilary Stoupa — Fri, 21 Mar 2014 15:47:25 GMT

Can you attach a screenshot of your data source (or the form itself) under the Options tab in a reply?

This is for IP 2003, but the same principles apply - perhaps take a look: http://office.microsoft.com/en-us/infopath-help/connect-a-form-to-a-database-RZ001187936.aspx

Re: InfoPath Form to Submit data to multiple rows in SQL table

gec13 — Fri, 21 Mar 2014 15:15:53 GMT

Hi Hilary

Thanks for your response, I can not see 'Repeating Group' in particular.

My aim is

1. Fetch data from database based on user input and display this data in multiple rows.

2. Submit this data to another database table in multiple rows.

Please guide me in detail.

Cheers

gec13

Re: InfoPath Form to Submit data to multiple rows in SQL table

Hilary Stoupa — Thu, 20 Mar 2014 18:50:09 GMT

When I create a database bound form, by default I'm getting a repeating group for the data fields in the data source - is that not happening for you?

Re: InfoPath Form to Submit data to multiple rows in SQL table

gec13 — Thu, 20 Mar 2014 17:02:55 GMT

Any one could please guide here!

Cheers

InfoPath Form to Submit data to multiple rows in SQL table

gec13 — Wed, 19 Mar 2014 14:18:17 GMT

I would be grateful, if someone could guide me (this may already have been asked before).

I am new to InfoPath and designed forms which Submit to one row in SQL table.

My question is, Is there any way that I can store information to multiple rows in SQL table?

If yes than which components should I use?

Many thanks in advance.