Submitting data back to the table

[sadhana]

Hi All,

My Question is How to submit data back to the table.

I am able to connect to sql server table and get the data to the infopath
form, after that I have to increment the ID and 've to resubmit it back to
the table or insert a field in the table. I tried the following code in
Form_Submit event handler, but it is not working.

(DataConnections("NAME AS ENTERED IN THE DATA CONNECTION WIZARD").Execute();
).

Any help in this regard is appreaciated.

Thanks

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

How did you design the Infopath form? Using the dataconnection or did you
add the data connection after designing the form?
Please read the link belo
http://enterprise-solutions.swits.n...tically-add-db-record-vbscript&c=infopath2003

I hope it will help you

 

[sadhana]

I have added data connection after designing the form. I think that's why, I
am unable to view the "queryFields" tab in the datasources in taskpane.

How to solve my problem.

Thanks
Sadhana

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

When you dont build the Infopath using the Dataconnection , You cannot
submit the form to DB. To overcome this you have to use a webservice to
submit data to the DB.

Please look into this product it might be helpful
http://www.qdabra.com/proddetail.asp?prod=QDBXL1

 

[sadhana]

Hi,

What are the steps if I want to submit the data through a WebService????

does it solve my issue?

Thanks
Sadhana

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Do you have a webservice already to submit the Data?

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Go through the Link belo
http://blogs.msdn.com/infopath/arch...-web-services-in-infopath-forms-services.aspx

I hope this will help you.