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 2 of 2 (17 items) < Previous 1 2 Re: Iterate through repeating table with complex SQL query Sorry, I'm not as of now. I have looked at what you provided, and made a few changes and put it into my form. Like I said, I'm not very familiar with C#, but I gave it my best shot. LOL Here is what I came up with: //get the nodelist ... Posted to Code (Forum) by cjg1979 on 03-24-2009 Re: Iterate through repeating table with complex SQL query I'll have a look at this in the next day or two. Honestly, I'm better with VB than C#, but I can pick my way through. :) I'm not really copying from one table to another, but rather querying a secondary data source (web service created in SQL) and using the query results as a single field in a repeating ... Posted to Code (Forum) by cjg1979 on 03-24-2009 Re: Iterate through repeating table with complex SQL query Ok, so no one has posted any help on this yet, and I have had it on the back burner due to some other projects. I have made some progress, however. What i have done is created a stored procedure to produce the sql query with the infromation that I need. The only thing left would be to figure out the XPathNodeIterator in ... Posted to Code (Forum) by cjg1979 on 03-24-2009 Re: How to refresh form on clear button click? Perfect! Exactly what i was looking for. I did make one modification, and that was that I closed the existing form, not asking to save changes before opening the new form. That way they don't end up with hundreds (in theory) of forms open, but only one at all times, either the one they are working on, or the new one they are ... Posted to Browser Forms (Forum) by cjg1979 on 03-24-2009 Iterate through repeating table with complex SQL query Some background: We are creating a form for our HR department that can be filled upon hiring. This form will contain all the user information in a single table, and a related table will hold all user information for the applications that they will need. What I would like is for HR to be able to click a "fill" button to ... Posted to Code (Forum) by cjg1979 on 01-28-2009 Re: Loop through repeating table That's exactly what I am going for. The solution I came up with to solve the problem and yet not write code is to have a hidden field in the main data connection that is filled by rules based on the secondary data connection, and use a nested eval command to loop through the email field to compose the email. This has worked well, ... Posted to Newbie Questions (Forum) by cjg1979 on 10-21-2008 Loop through repeating table I have what I think should be a rather simple problem, but to a complete n00b like me, it's daunting at best. The basic scenario is this: I have a database set up for new employees of our company. Upon hire, our HR department will fill out a form (only the top portion) with employee information (Name, User Name, Email Address, ... Posted to Newbie Questions (Forum) by cjg1979 on 10-15-2008 Page 2 of 2 (17 items) < Previous 1 2 Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.