InfoPath Dev

This is my full button code: Dim myAdoQueryConnection As AdoQueryConnection = Me.DataConnections("ETS_Group_Engagement") myAdoQueryConnection.Command = "update formdb..Group set IDCode = '1111' where IDCode = '3435-235' "  myAdoQueryConnection.Execute()I'm not sure why the double quotes came ...

Hi Jimmy, It worked now. I believe its due to a repeated mapping as seen in attached screenshot. I have another MSLB where instead of removing the selections, I add them to another table. It seems that was causing some confusion for the mapping. I've removed the maps and will map to a new table now. Now all I need is hopefully run a stored ...

There were no errors on execute. But the table column values were not updated. Is my ADOQueryconnection coding correct?

Hi Jimmy, I tried adding the dot (.) and the xpath directly, both methods did not work. When I reshred, I get an error, "The value for key value "EngagementCode" is unspecified. All key values must be specified." It seems my selections in the MSLB are not detected. How did you get your selections to be detected?

Hi Jimmy,  Unfortunately, did not work for me. Attached are some screenshots of my data source and DB mapping. For the mapping I have the MSLB's group holder "Group_Engagement..." and for the EngagementCode which I am trying to store as separate DB rows, I have mapped "Group_Engagement.."'s child node. This worked ...

Hi Guys, Has anyone tried having a multi selection listbox (populated with secondary data source) in their form and pushing the user selected values into a SQL database via DBXL database mapping? Can this work? So far, I am only able to insert multiple rows into my database table when my multiple fields come from a repeating table. ie, I ...

Hi again, Just tested and somehow we are able to connect to the database table which we configured the DB data connection (we gave rights to the DBXL service account to our database directly. Using web service calls, this was not required). However, we are not able to execute any Adoconnection.command. Our code is ...

 Hi Hilary, Thanks for your reply! Opening up our DB with read access to all users might not be such a good idea, in any case, I'll give it a try with an account which has read access. Will we be able to use code to run stored procedures if we use a web service connection to our database? Because we are able to use web service to pull ...

 Hi Patrick,  Sounds like the same issue I faced when I preview the form and my database data shows, when I publish and open the form, the data can't be drawn and there is no error message. I am using a Database data connection to my SQL server. Are you recommending we use DBXL's web service always? The reason why I am using ...

Hi, We are using Infopath 2007 and I'm having difficulty trying to code my form to run some stored procedures from my SQL server. What I have in my button code is:Dim myAdoQueryConnection As AdoQueryConnection = Me.DataConnections("DataConnection") myAdoQueryConnection.Command = "exec ...