<?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>How do I solve the Infopath Repeating table problem</title><link>https://www.infopathdev.com:443/forums/thread/77858.aspx</link><pubDate>Mon, 23 Apr 2012 14:56:36 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:77858</guid><dc:creator>Rahul2011</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/77858.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=77858</wfw:commentRss><description>Hi all,

I have been enjoying working in infopath but sometimes the repeating table is killing me, please help me somebody for the below problem. 

I am integrating the infopath form with ERP database using custom webservices call in button click event. I am creating sales order thru infopath in ERP, 
I have designed the repeating table something like below:

NO      ItemNo   Descrption    Quantity    Unit Cost   Cost 
1         1            Item1             1               1200           1200
2         2            Item2             2               200             400
3         3            Item3             3               300             900
4         4            Item4             4               100             400
    
                                                                    Total: 2900

After Clicking on the SOP Button the value of repeating table getting changed the above repeating table becomes after clicking on Button like below:

NO      ItemNo   Descrption    Quantity    Unit Cost   Cost 
1         4            Item4             4               100             400
2         2            Item2             2               200             400
3         3            Item3             3               300             900
4         4            Item4             4               100             400
    
                                                                        Total: 2100

By seeing i can understand the 4th Item i.e last one is replacing the 1st Item. Why its is happening how can i solve this Pls somebody help me out, i 
am not getting any clue.</description></item></channel></rss>