<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Rules and Custom Code to create new record in SQL</title><link>https://www.infopathdev.com:443/forums/thread/73016.aspx</link><pubDate>Fri, 16 Dec 2011 14:30:59 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:73016</guid><dc:creator>pelizdr</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/73016.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=73016</wfw:commentRss><description>&lt;p&gt;I have been working on an InfoPath form with a connection to SQL server.&amp;nbsp; The standard SQL button options have the ability to create a new record.&amp;nbsp; Great feature, but how do I add that to custom code?&amp;nbsp; My submit button is doing a lot of stuff (like hiding sections, showing sections, sending e-mail, etc...) but I would also like to have it submit to SQL and start a new record once that is done without using two buttons.&amp;nbsp; What happens now is someone clicks on submit, the record is created, but any subsequent &amp;quot;additions&amp;quot; are modifying the original record.&amp;nbsp; This happens until they close the form.&lt;/p&gt;
&lt;p&gt;Any assistance would be greatly appreciated.&lt;/p&gt;</description></item></channel></rss>