<?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: Issues with calculation while retrieving data from backend(SQL)</title><link>https://www.infopathdev.com:443/forums/thread/28889.aspx</link><pubDate>Fri, 23 May 2008 09:37:48 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:28889</guid><dc:creator>sandhyarani</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/28889.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=28889</wfw:commentRss><description>&lt;p&gt;i have completed the task using the code. But i want to some rules kind of thing to get the things done because of performance issue .&lt;/p&gt;&lt;p&gt;Can anyone help me?&amp;nbsp;&lt;/p&gt;</description></item><item><title>Re: Issues with calculation while retrieving data from backend(SQL)</title><link>https://www.infopathdev.com:443/forums/thread/28794.aspx</link><pubDate>Mon, 19 May 2008 12:59:01 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:28794</guid><dc:creator>sandhyarani</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/28794.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=28794</wfw:commentRss><description>&lt;p&gt;Hi,&lt;/p&gt;&lt;p&gt;I am searching for this solution for long time and end up with no result.&lt;br /&gt;&lt;/p&gt;&lt;p&gt;If there is no other way other than the code,can you provide with some working examples regarding this?&lt;/p&gt;&lt;p&gt;please help me&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks in advance&lt;/p&gt;&lt;p&gt;Sandhya&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>Issues with calculation while retrieving data from backend(SQL)</title><link>https://www.infopathdev.com:443/forums/thread/28724.aspx</link><pubDate>Wed, 14 May 2008 13:06:04 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:28724</guid><dc:creator>sandhyarani</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/28724.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=28724</wfw:commentRss><description>&lt;p&gt;Hi,&lt;/p&gt;&lt;p&gt;I m developing an application of timesheet based on week-wise analysis. I have a repeating table allowing users to enter their timings they worked on everyday and this data is submitted to the SQL after the user clicks submit.And when user clicks on the date which falls into the same week then the timesheet should be opened with all the data entered by the user previously.&lt;/p&gt;&lt;p&gt;Till here it works fine.&lt;/p&gt;&lt;p&gt;My problem is,&lt;/p&gt;&lt;p&gt;When the user enters timings everyday on different projects,the total time is calculated and is displayed in the textbox which is present in the footer of the repeating table for day-wise and the total time spend on the project for a week is displayed in the textbox which is present inside repeating table.&amp;nbsp;&lt;/p&gt;&lt;p&gt;This is working fine when a new row is inserted but fails to work with values fetched from backend and not able to update along with the previous values.&lt;/p&gt;&lt;p&gt;I have set the calculation formula for the respective days in the default value of the textboxes. And for fetching the values from backend i am using the formcode in the changing event of the datepicker so that the user gets data if present on that date else empty table is viewed to allow him to enter new data and submit it.&amp;nbsp;&lt;/p&gt;&lt;p&gt;Can anyone help me?&lt;/p&gt;&lt;p&gt;Thanks in advance.&lt;/p&gt;&lt;p&gt;Sandhya.&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item></channel></rss>