<?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>Submit to a SQL Database</title><link>https://www.infopathdev.com:443/blogs/greg/archive/2004/07/27/Submit-to-a-SQL-Database.aspx</link><description>When creating a new form from a SQL database connection, there are a couple of things to remember in order to enable the Submit To Database feature. The SQL tables used must have a primary key, unique constraint, or unique index. Without this you will</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>re: Submit to a SQL Database</title><link>https://www.infopathdev.com:443/blogs/greg/archive/2004/07/27/Submit-to-a-SQL-Database.aspx#63947</link><pubDate>Mon, 07 Feb 2011 23:05:11 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:63947</guid><dc:creator>ramii</dc:creator><description>&lt;p&gt;Hi Greg, thanks for the post. I have similar question regarding retrieving the records from multiple tables, I was able to retrieve it from a table using its primary key. However if I try to retrieve it using any other column in the table its not populating any results. I appreciate if you can give some suggestion on it.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Ramii&lt;/p&gt;
&lt;img src="https://www.infopathdev.com:443/aggbug.aspx?PostID=63947" width="1" height="1"&gt;</description></item><item><title>re: Submit to a SQL Database</title><link>https://www.infopathdev.com:443/blogs/greg/archive/2004/07/27/Submit-to-a-SQL-Database.aspx#53279</link><pubDate>Wed, 31 Mar 2010 16:37:51 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:53279</guid><dc:creator>chris leate</dc:creator><description>&lt;p&gt;Does anyone know if the same restrictions regarding long binary types applies to web methods? &lt;/p&gt;
&lt;p&gt;I tried using UDC but the restriction of data is annoying and I would like to use nVarchar as well as storing data such as attachments. &lt;/p&gt;
&lt;p&gt;Is this just a restriction of UDC or is it more widespread?&lt;/p&gt;
&lt;img src="https://www.infopathdev.com:443/aggbug.aspx?PostID=53279" width="1" height="1"&gt;</description></item><item><title>submit data from infopath to SQL | keyongtech</title><link>https://www.infopathdev.com:443/blogs/greg/archive/2004/07/27/Submit-to-a-SQL-Database.aspx#37492</link><pubDate>Thu, 22 Jan 2009 01:12:36 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:37492</guid><dc:creator>submit data from infopath to SQL | keyongtech</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;submit data from infopath to SQL | keyongtech&lt;/p&gt;
&lt;img src="https://www.infopathdev.com:443/aggbug.aspx?PostID=37492" width="1" height="1"&gt;</description></item><item><title>re: Submit to a SQL Database</title><link>https://www.infopathdev.com:443/blogs/greg/archive/2004/07/27/Submit-to-a-SQL-Database.aspx#24512</link><pubDate>Fri, 16 Nov 2007 16:49:01 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:24512</guid><dc:creator>bobspearing</dc:creator><description>&lt;p&gt;This isn't available - &amp;quot;To drop-down list box should have the value Database pre-selected.&amp;quot;&lt;/p&gt;
&lt;p&gt;I'm going crazy here trying to submit!&lt;/p&gt;
&lt;img src="https://www.infopathdev.com:443/aggbug.aspx?PostID=24512" width="1" height="1"&gt;</description></item></channel></rss>