Search - InfoPath Dev Sign in | Join | Help 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 Search More Search Options Page 1 of 2 (17 items) 1 2 Next > Re: Iterate through repeating table with complex SQL query You're a genius! That worked exactly like you'd expect it to. Now I need to sit down and study your code, and see if I can wrap my head around it enough to put it into VB so that I can reuse the concepts. Thank you so much! You've taught me an invaluable amount of information. Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query The field, in comparison to the @Applications field, would be @Officer, @Backup_Officer, @Officer_Email, @Backup_Email. LOL All of those fields are filling automatically when I select from the drop down, just can't for the life of me get them to fire when the code is applied. I have a custom submit button (because I submit ... Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query Which is exactly what I thought. The result, however, was unexpected. It gives me a blank first line and does not fire the rule. Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query Yes, the rule is set on @Applications node of the data being filled in with this code. The rule is to set the Officer field filtered with @Application=current(). public void CTRL66_7_Clicked(object sender, ClickedEventArgs e) ... Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query Dang you guys are good. :) Jimmy, I used your solution for the first line, solved like a charm. Hillary, I made the change you suggested, and it gives me a blank first line again, but does not fire the rule. Maybe I simply need to apply the rule to something else...although I can't figure out what...since the ... Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query Yay, both options work. But the first line is simply blank, which I thought the child.DeleteSelf() would take care of..(odd), and the rule that is applied to the field being set to a value isn't firing. If you have some quick ideas, I'd be appreciative, but you've both done more than I could imagine. :) ... Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query public void CTRL66_7_Clicked(object sender, ClickedEventArgs e) { //get the nodelist from the secondary data source -- replace the data source name and xpath with your data source and xpath ... Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query Well you're absolutely correct. Again, like my first post said, I'm learning XPath and such now. I simply copied the XPath from my data sources and pasted them in, and we do get a better, yet not correct, result. The result now is that the repeating table does fill, but every entry is the first in the query ... Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query So in order to overcome the possibility that the data source wasn't being queried again, I added an action to the drop down list of positions. Now it does two things: set the query field value, and query the data source. If my thinking is correct, this should populate the source with the data for the table, and when the ... Posted to Code (Forum) by cjg1979 on 03-25-2009 Re: Iterate through repeating table with complex SQL query Well, if I had been awake, I should have caught it. Unfortunately, it didn't make any difference. I still get the NullReferenceException error. I've changed it to simply "Application", as this is the node name in the secondary datasource. It's almost as if the error occurs before it gets to the node ... Posted to Code (Forum) by cjg1979 on 03-24-2009 Page 1 of 2 (17 items) 1 2 Next > Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.