Repeating table won't allow repeats - InfoPath Dev Sign in | Join | Help in Browser Forms InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Browser Forms » Repeating table won't allow repeats Repeating table won't allow repeats Last post 02-05-2009 05:16 AM by punkn00dlez. 2 replies. Page 1 of 1 (3 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 02-04-2009 01:50 PM punkn00dlez Joined on 11-17-2008 Posts 23 Repeating table won't allow repeats Reply Contact My repeating table won't allow users to insert or delete rows. It's connected to a table in my sql db. I'm in the process of setting up a web service to write the InfoPath data to the SQL server since the form is set up to be web compatible. 02-04-2009 06:19 PM In reply to Patrick Halstead Joined on 08-08-2006 Posts 5,112 Re: Repeating table won't allow repeats Mark as Not AnswerMark as Answer... Reply Contact You'll have to redo your main data source for your form. You'll want to start from an XML schema to allow future schema changes and not be bound to the receive schema from the Web Service (that's what limited the insertion for your current forum since InfoPath derives a read-only schema when you create from a DB - to preserve the mapping since if you just change a group to be repeating it wouldn't know how to insert into SQL). Good luck with mapping repeating nodes to your DB via the Web Service. It's some work to get the recursion working, etc. Our meta Web Service (DBXL) already does this out-of-the-box and would take you 5-10 minutes to set up for an XML-schema based IP form. Might save you some time and money down the road .... just my 2 cents. Patrick HalsteadProject Manager at Qdabra 02-05-2009 05:16 AM In reply to punkn00dlez Joined on 11-17-2008 Posts 23 Re: Repeating table won't allow repeats Mark as Not AnswerMark as Answer... Reply Contact I bet it would, unfortunately there's no way anyone would approve buying it. I am, however, going to check out the trial for DBXL. I've never done this before so it'll be great learning experience-especially since I know nothing about XML. Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
My repeating table won't allow users to insert or delete rows. It's connected to a table in my sql db. I'm in the process of setting up a web service to write the InfoPath data to the SQL server since the form is set up to be web compatible.
You'll have to redo your main data source for your form. You'll want to start from an XML schema to allow future schema changes and not be bound to the receive schema from the Web Service (that's what limited the insertion for your current forum since InfoPath derives a read-only schema when you create from a DB - to preserve the mapping since if you just change a group to be repeating it wouldn't know how to insert into SQL). Good luck with mapping repeating nodes to your DB via the Web Service. It's some work to get the recursion working, etc. Our meta Web Service (DBXL) already does this out-of-the-box and would take you 5-10 minutes to set up for an XML-schema based IP form. Might save you some time and money down the road .... just my 2 cents.
I bet it would, unfortunately there's no way anyone would approve buying it. I am, however, going to check out the trial for DBXL. I've never done this before so it'll be great learning experience-especially since I know nothing about XML.