Data Connections

Re: Creating a table on a SQL database server using InfoPath 2007

p1024 — Tue, 16 Oct 2012 15:07:43 GMT

Oh, so I should start creating my form after creating my table to have the built-in submit button...

Im going to try this to see what happens. I let you know when it works, guys!

Thanks a lot

Re: Creating a table on a SQL database server using InfoPath 2007

Hilary Stoupa — Tue, 16 Oct 2012 14:42:00 GMT

And just to clairfy a little further - to use the built-in submit, you'll want to base the InfoPath form off the table. So when you go to create the new form, select the Database option.

Re: Creating a table on a SQL database server using InfoPath 2007

budtsa80 — Tue, 16 Oct 2012 11:39:42 GMT

Hi p1024,

Yes, you will need to have the table created in the database with all of the required columns.
Be sure to have your InfoPath field data types match up with the corresponding columns in the table to ensure that there are no exceptions raised on insert.

Re: Creating a table on a SQL database server using InfoPath 2007

p1024 — Tue, 16 Oct 2012 01:50:38 GMT

sorry about that.. but thanks because I didn't noticed that I caused confusion with my post My manager created a database in SQL with no tables. What I want to know is when an InfoPath form is being submitted to a database, does it create a table in the database with the right parameters? Or do I have to create a table in the database to submit this data?

Re: Creating a table on a SQL database server using InfoPath 2007

Gennady Vanin (Геннадий Ванин, Новосибирск) — Tue, 16 Oct 2012 00:11:35 GMT

I believe it is next to impossible to answer you since it is incomprehensible what you are writing

p1024:
I created an SQL database and i wanted to submit information fon an infopath form that i created to that database

Created "SQL database" with which tables? where and how (What do you mean under "SQL database"? Which DBMS?)?

Submit from where to where what and how (this is usually is defined in data connection wizard to a database)?

Creating a table on a SQL database server using InfoPath 2007

p1024 — Mon, 15 Oct 2012 15:32:46 GMT

I have been working now for a long while with InfoPath and I have found a challenge.. I created an SQL database and i wanted to submit information fon an infopath form that i created to that database. My question is: since i created this form, i wanted it to submit the information to this database. How is InfoPath going to create a table and how is it going to pick the parameters for each column after submission of the form? I need help with this because I don't know wether i have to make a table in the database in order to be able to submit the InfoPath form.

Thanks!