Write DATA in SQL and XML Files

[Jean]

Hi,

I am beginer in InfoPath.

I would like to know when a submit an InfoPath Form can I write, both of
1 - Write data to SQL table
2 - Save InfoPath From and Data to file

And what in necessary to develop for that ?

Thank you for your answer.

Jean.

 

[Alessandro Catorcini [MSFT]]

Submit and Save are two different actions, so not only can you do both the
actions that you want to do, but you can also do them without the need to
write a single line of code unless you need to add something more complex.

All you need is to start your template as a template that works against a
SQL table. Unless you have complex relations in the tables involved in your
query, you will be able to submit back.

And after submitting, you can always save locally the form (the XML data you
entered), unless you want to prevent it.

The Form template (i.e. the whole logic of the form, including its views) is
stored separately and cached the first time you use a given template.

Hope this helps

--Alessandro

 

[Bryce]

Hello,

I have been using InfoPath for about a month now. I have a form that we are
using for Daily Maintenance. Once complete, it sends an e-mail and saves the
form to out Share Point server. Everything works great. I am also querying
a SQL database to populate some drop down lists. Recently, I decided that I
want to submit certain field in the InfoPath form to a SQL database.

My problem is that I cannot find anywhere in InfoPath that allows me to
submit data to a SQL server. Does this require me to write custom code /
scripts? When I go to create a data connection with the action of "Submit",
it only allows me to choose between a web server, share point, etc, but SQL
is not an available item.


Any help would be appreciated.

Thank you,

Bryce