https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/53230.aspxTue, 30 Mar 2010 11:22:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53230silverj0https://www.infopathdev.com:443/forums/thread/53230.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=53230<p>Afternoon All</p> <p>&nbsp;I am trying to set a flag in a sql database once a user has clicked on a button within an infopath 2003 form. </p> <p>&nbsp;I have set up a simple test which does not seem to be working and I am at a loss as to say why </p> <p>&nbsp;The code within the button is ...</p> <p>&nbsp;</p> <p>function CTRL262_7::OnClick(eventObj) </p> <p>{</p> <p>&nbsp;XDocument.QueryAdapter.Command = &quot;Insert into d_TEST SELECT &#39;Test9&#39;&quot; ; </p> <p>XDocument.Query(); </p> <p>}&nbsp;</p> <p>&nbsp;Can anybody see what I have done wrong?&nbsp;I have also tried to execute it as a stored procedure with no success and my sanity is starting to fray at the edges now! </p> <p>&nbsp;</p>