InfoPath Dev

I take it that is from the copy of the template I gave you? In your original, it was still succeeding?

Can you put the QdabraRules execution history on your form and verify that the Modify SQL Query command for the approvers data connection is returning success? The command is supposed to execute the query, but if GetXml /dsname=approvers isn't returning any data, that would indicate there is no data being returned to the form... I also noted ...

So - to me, this indicates no data has been returned in that data source. You can check this by checking a different data connection - do you have other data connections in your form? You can also just use GetXml and it will return the main data source XML to the results field so you can see how the command works.... But I guess the next thing ...

Sounds like you may be trying to put that text in a formula editor. Put the qRules command and result field on the form so you can just enter the text as you have it into the command field and tab out: GetXml /dsname=approvers

Can you tell me how you want the form to behave? Should the user enter all their data, then click the button to get data for all rows? Or do you want them to click the button to populate each row? Here's a code sample that may help you iterate through the main nodes and set values: ...

Any time you requery your secondary data connection, it will only contain the data you have queried for. You could copy the queried data to the main data source for each row - then you don't have to query for all the questions each time, and the data returned to your form is preserved (stored in the main data source). I'd probably do that. ...

If you always want to query for the last question ID you could use: xMain.SelectSingleNode("/my:myFields/my:group1/my:group2[last()]/my:QuestionID", nSpace).Value. But otherwise, if your button is not in the repeating table, I'm not sure how we'd guess what question id to run the query for :)

Hi! so your button is in the repeating table? Your XPath in this line will always return the first node: xMain.SelectSingleNode("/my:myFields/my:group1/my:group2/my:QuestionID", nSpace).Value. That's going to get you the first QuestionID, always, as you have found. Good news - your button is context aware and knows what instance of ...

If you use GetXml /dsname=YourDataSourceName in the qRules command field, XML should be returned in the Result field - that would be at least a start to figuring out what's up.... is the XML returned what you expect?

First, your tag game is on point. Second - I wonder if the data returned from the stored procedure changed at all? Perhaps the data connection fields don't align with what is currently being returned from the stored procedure? You can use the qRules command: GetXml /dsname=YourDataSourceName to get back the actual XML in the data connection ...