Inserting into a database table from Infopath

[Patrick Temple]

So all I want to do is grab a auto-incremented number from my SQL Server
database and then add a new row to the database table so the number gets
incremented.

Then I can use the number as an id for the doc I'm creating and storing in
Sharepoint.

I can create a secondary data source to grab the max(id) number that I want.
I assumed you could modify the SQL query created by data source wizard to do
inserts but I get errors when I try this. Is there another way of calling an
insert to a database in infopath 2003? Can you call an insert to a database
in infopath?

 

[Rick]

I have not done this, but it is possible to run a stored procedure from
infopath, if you have a stored procedure to do your insert it should work.
Try this link:

http://www.kbalertz.com/kb_827007.aspx

 

[Patrick temple]

Rick,

Thanks, I was able to create a couple of stored procedures to insert a row
and retrieve the Max(id) from the article you listed.

--Patrick