Re: Deleting a row from a SQL database using Infopath 2007

bahrom7893 — Tue, 17 Aug 2010 19:03:59 GMT

Potemkine:

Can you please show the codes of your delete function?

Tnx for the response, and never mind, I got it figured out, something was wrong with the parameters.

Re: Deleting a row from a SQL database using Infopath 2007

Potemkine — Mon, 16 Aug 2010 12:27:01 GMT

Can you please show the codes of your delete function?

Deleting a row from a SQL database using Infopath 2007

bahrom7893 — Mon, 16 Aug 2010 11:55:25 GMT

Hi,

I'm trying to make a web services template in infopath 2007 which is connected to a SQL 2008 database. It has a "run query" button, which shows the rows in the database when someone clicks on it and a "delete" button under every single row that shows up. When someone click on the "delete" button under a specific row, for example 2, row 2 must be deleted from the database; however, when I preview the form and click the delete button under a specific row, it always deletes the 1st row, regardless of my choice (when I click the button under the row 2,3,4,5,etc., it deletes the 1st row regardless of my choice). The "delete" button submits the form to a Web service, which in turn should delete a specific row. Can somebody please tell me what is wrong with the form/web service?

Thank you,

Bahrom

Newbie Questions

Re: Deleting a row from a SQL database using Infopath 2007

Re: Deleting a row from a SQL database using Infopath 2007

Deleting a row from a SQL database using Infopath 2007