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