<?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>Re: Custom SQL Commands?</title><link>https://www.infopathdev.com:443/forums/thread/51196.aspx</link><pubDate>Sat, 30 Jan 2010 13:23:57 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:51196</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/51196.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=51196</wfw:commentRss><description>&lt;p&gt;A lot depends on how your form is set up and what event your code is in. Is your code in the Submit event of the form? What does your code look like?&lt;/p&gt;</description></item><item><title>Custom SQL Commands?</title><link>https://www.infopathdev.com:443/forums/thread/51050.aspx</link><pubDate>Wed, 27 Jan 2010 17:27:50 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:51050</guid><dc:creator>cmbrooks08</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/51050.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=51050</wfw:commentRss><description>&lt;p&gt;&lt;font size="2" face="Verdana, Arial, Helvetica"&gt;I&amp;#39;m using Infopath against a SQL Server database, and am trying to write the  
&lt;br /&gt;
VB code to execute custom SQL commands, like Updates and Deletes.  When I  
&lt;br /&gt;
test, if I don&amp;#39;t add any new data to the form, then I get an error saying  
&lt;br /&gt;
that no new data exists to submit, even though the code is an update  
&lt;br /&gt;
statement to set the entire table to null.  If I do just add a record with  
&lt;br /&gt;
dummy data, then choose the button, it  just submits that data and ignores  
&lt;br /&gt;
the code completely. 
&lt;br /&gt;
 
&lt;br /&gt;
Are custom SQL statements not possible?&lt;/font&gt;&lt;/p&gt;</description></item></channel></rss>