https://www.infopathdev.com:443/forums/131.aspxqRules adds support to your InfoPath forms. With qRules, you can add features to your form that require code, but without having to write it. enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/94397.aspxTue, 19 Nov 2013 22:54:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94397TomRenfro0https://www.infopathdev.com:443/forums/thread/94397.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=94397<p>That was it.&nbsp; You&#39;re the best!</p>https://www.infopathdev.com:443/forums/thread/94396.aspxTue, 19 Nov 2013 22:41:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94396Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/94396.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=94396<p>&nbsp;Hi, Tom - the command should work in preview mode. I&#39;m wondering if the issue is your stored procedure. I&#39;ve found that stored procedures I use in InfoPath via IP data connections need to have implicit transactions set to off - <a href="http://msdn.microsoft.com/en-us/library/ms187807.aspx">http://msdn.microsoft.com/en-us/library/ms187807.aspx</a>&nbsp;- can you try that?</p>https://www.infopathdev.com:443/forums/thread/94386.aspxTue, 19 Nov 2013 20:06:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94386TomRenfro0https://www.infopathdev.com:443/forums/thread/94386.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=94386<p>Hi, I&#39;m attempting to use the ExecuteSqlQuery command to fire a stored procedure against&nbsp;a SQL table.&nbsp; I have a column in the table called Entry_Deleted, which is a true/false column as opposed to just deleting the entry.&nbsp; When the procedure is executed, it changes the value to 1 for true according to the userID.</p> <p>I have a receive data connection in the form to the table, and in a button rule, I&#39;m querying the data connection, then running the qRules command.&nbsp; Here&#39;s the command: concat(&quot;ExecuteSqlQuery /dsname=DARP /sql=EXEC dbo.MarkAsDeleted @UserID = &#39;&quot;, my:UserID, &quot;&#39;&quot;)</p> <p>I&#39;m not getting any errors from qRules, but nothing&#39;s changing in the database.&nbsp; I&#39;m attempting this when previewing the form, and I do know that it needs to be admin deployed and the data connection changed to a UDC for using in a browser.</p> <p>What do you see that might be missing, or does it just not work in preview mode?</p>