submitting data to database!

[MMJ]

well .. i was just exploring InfoPath ... and it occured to me that u cannot
submit data to the database directly .... i mean insert a record in a
database!

there is a an option under actions in the rules section that sayz "submit
using data connection" but no database connection option is present

it seems that if one wishes to insert record /change the database, one has
to either write a script, or send a request to a custom webservice to get the
task done

is it really like that? correct me if i m wrong!! is there any special
reason y submit to database option is not included???

 

[Shailaja]

Hello MMJ,

If you are trying to both retrieve and submit data, then you would have to
create an InfoPath form which has the SQL connection as the main Data
connection. To do this please follow the steps below
1. In Design a Form task pane, click on New from Data connection
2. Create a data connection to the specific SQL DB in the data connection
wizard that comes up. In the last window of the data connection wizard you
will be told if Submit is allowed or not to this specific table in the
database.
3. This will create some default UI to be able to insert.
4. Submit is allowed based on text shown in the last window in the wizard -
you will be able to enable submission of forms using Tools -> Submitting
forms. This will allow you to update existing data in the database.

Hope this helps!