InfoPath Dev

Thanks again, I tried the xMain.SelectSingleNode("/my:myFields/my:group1/my:group2[last()]/my:QuestionID", nSpace).Value it works and brings the new value But the problem is now the previews results from the first row disappeared, I want every search result to stay in repeating table I set the fields value using this formala ...

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 Hilary, Thank you so much for your reply! The button is not in repeating table its outside of the repeating table. when I enter the question ID in repeating table column and click search the first search works when I add new row and type new questions ID it's not querying the second record

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 ...

Hello Everyone, I have an Infopath 2013 form, which pulls some records info from a sql servers. I want a manual query, I have a field - QuestionID on each line of the repeating table, where user will enter a QuestionID. The search button will look up records in the SQL DB . The first line works perfectly. Problem happens when I add a ...

Thank you so much for the detailed explanation!

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?

we tried recreating the connection from scratch in a new form with the same results.

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 ...

I'm having problems with a form handed down to me. we recently went through some changes with the stored procedure and it now requires an additional parameter. we've been using the modifysqlquery command in qrules to achieve this, however after altering the procedure and adding the additional parameter, the query returns nothing. no ...