Search - InfoPath Dev

InfoPath Dev

Search

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.