InfoPath Dev

Thanks Hillary.  The static query works but I need to pass a variable to the query.  I have tried to concat everyway I can think of the string to pull in the input field which is in the main.  I copied the code generated by Query Builder and I copied the piece of code that I was using in the Rule to set the query field of the ...

OK.  I lied!  Well not really.  I have progressed nicely since this morning.  Everything is going fine but I moved on to finishing the code for this.  What I now need to do is combine the query function to DBXL with the rest of the code.  I had been doing the query in Rules but now I want to call the query from ...

Well Hillary to not be a Java Script girl you are doing wonderfully.  That did it.  I had tried similar combinations all around that but had not hit that combination I guess.  Works like a charm. Now lets try and add all the other fields and see what I get into!  I'll leave you alone for the rest of today unless I hit ...

Here's the current script.  I added the Alert for the length of the node just for debuggin.  It will show me the node size for the records just fine up until it hits that one where this none has not been filled in yet and I Object Required. I had already tried to test for null just like mentioned:  var field = ...

  OK,  It still appears that since that field is not populated it is just not there?  It keeps giving me an object required error when I get to that point.  I tried using the null comparison but that doesn't work either.  I tried using .length and it gives me the lengths for the items up to the one without anything ...

Good grief Charlie Brown.  One step at a time! So with a little work I got the nil attribute to work. Now I have encountered a situation where there i a record but it has no Diameter input in it as of yet.  This could happen.  I have tried to test it comparing for null and undefined but neither seems to work.  I may be ...

OK.  That worked for the first field, field 10.  So now I tried to proceed cautiously by expanding to one for more field and it's blowing up with this error:  '#PCDATA' is in nil content: ...

Here it is.  View 1 is the view i'm working in to trouble shoot this. I run the query by itself at this point using rules and then the COPY button executes the JS to attemp to copy the information from the secondary into the main.  I will be moving multiple fields once I get it working but no reason to work with more than one during ...

Yes, it populates the repeating table that I have bound directly to the secondary DBXL connection but I cannot use that repeating table because I need to be able to remove and insert other lines in the table. Also, If I direct the result to just a field on the form that is not a repeating table it populates it.  It just does not work when ...

Happy Monday to all.  So Hillary I tried your suggestion of this code:      // Get a copy of the main DOM node.      var clone = XDocument.DOM.selectSingleNode("/my:myFields/my:group3/my:Test_Details").cloneNode(true);      // Clear the main DOM nodes. ...