<?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>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If 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.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: InfoPath decimal equivalent to what data type in SQL?</title><link>https://www.infopathdev.com:443/forums/thread/90511.aspx</link><pubDate>Fri, 07 Jun 2013 21:32:13 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:90511</guid><dc:creator>nemo385</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/90511.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=90511</wfw:commentRss><description>&lt;p&gt;Nvm. I found it. All i had to do was change my fields properties to double data type in my web service. SQL has float data type as-is. InfoPath field has decimal data type as-is. It worked. &lt;/p&gt;</description></item><item><title>InfoPath decimal equivalent to what data type in SQL?</title><link>https://www.infopathdev.com:443/forums/thread/90510.aspx</link><pubDate>Fri, 07 Jun 2013 20:39:27 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:90510</guid><dc:creator>nemo385</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/90510.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=90510</wfw:commentRss><description>&lt;p&gt;Hi,&lt;/p&gt;&lt;p&gt;I have a 2010 browser based IP form that submits data to SQL server 2008 via web service(custom asp.net).&lt;/p&gt;&lt;p&gt;Here&amp;#39;s my challenge:&lt;/p&gt;&lt;p&gt;I have few fields that have decimal(double) data type in IP form. In SQL server table I created float data type for those fileds. Now my value for the field in form&amp;nbsp; looks like this &lt;strong&gt;8006.&lt;/strong&gt; In SQL server it is submitted as &lt;strong&gt;8005.77978515625&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;field with value &lt;strong&gt;9007.98&lt;/strong&gt; is submitted as &lt;strong&gt;9007.98046875.&lt;/strong&gt; How do I correct it? My web service also has float data type for those fields properties.&lt;/p&gt;&lt;p&gt;Thanks.&lt;/p&gt;</description></item></channel></rss>