Qdabra qRules

Re: Insert command: Not adding rows - no error message.

Sam Camblin — Fri, 14 Aug 2009 15:06:51 GMT

Hilary & ErnestoM,

Its working now. Thank you so much!

Re: Insert command: Not adding rows - no error message.

ErnestoM — Fri, 14 Aug 2009 14:55:29 GMT

Hi Sam,

Perhaps it was accidental. When I preview the form it tells me that it cannot find the source code. Also, if I go to Tools > Form Options > Programming, I see the project location for code: C:\Documents and Settings\sbcamb\My Documents\InfoPath Projects\Add Recommendations Test\Trial - Master Detail.vbproj. I'm guessing that qRules doesn't like this (can't coexist with code) - that's why you don't even get an error message popup.

Anyway, I figured out a way to fix this without having to recreate the form.

1. Go to Tools > Form Options > Programming and remove the code.

2. Save the form template

3. Reinject qRules.

4. Preview, try it, it works!

EDIT: Hilary, you're too quick for me.

Re: Insert command: Not adding rows - no error message.

Hilary Stoupa — Fri, 14 Aug 2009 14:51:01 GMT

This form does have its own code module -- and the manifest.xsf file is using it instead of the qRules dll. You need to go to Tools / Form Options / Programming and select the 'Remove Code' button to delete the association to the code file. Save and close the form, then re-inject with qRules.

It is really easy to accidentally add an event handler, no doubt that's what happened in your case...

Re: Insert command: Not adding rows - no error message.

Sam Camblin — Fri, 14 Aug 2009 14:37:53 GMT

Hi ErnestoM,

Thank you for your quick response!

I've changed the child path per your suggestion on the attached form, but it's still not working. Here is what I used: Insert /parent=/my:myFields/my:Recommendations /child=/my:Table /count=1 (see attached).
I didn't think I added code. I just added a "detail" button using the existing controls in InfoPath (see below). Is this considered adding code?

Detail Button:

The "detail" button on the repeating table switches to the detail view displaying repeating section with controls. This is similar to Matt Faus blog (below). The only difference is my form uses a repeating table instead of a Matt's master/detail control.

The Detail button actions are:

Set a field's value: DetailID = Number
Switch to view: Detail

Matt Faus's blog is:

http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-an-InfoPath-Data-Filter.aspx

Re: Insert command: Not adding rows - no error message.

ErnestoM — Fri, 14 Aug 2009 13:18:28 GMT

Hi Sam, I see two problems:

1. /child is a relative path, so it should be /my:Table.

2. qRules cannot coexist with code. It looks like this form has code. Can you confirm?

Re: Insert command: Not adding rows - no error message.

Sam Camblin — Fri, 14 Aug 2009 12:55:45 GMT

Hi Hilary,

I tried both ways. I currently have it pasted into the Value text box. Attached is the file. Thoughts?

Re: Insert command: Not adding rows - no error message.

Hilary Stoupa — Thu, 13 Aug 2009 19:52:58 GMT

Don't click the fx button to open the formula editor, simply paste into the Value text box.

Re: Insert command: Not adding rows - no error message.

Sam Camblin — Thu, 13 Aug 2009 19:34:20 GMT

Hi Hilary,

Thanks for your quick response. I pasted what you provided and verified the formula and it says: "Insert/parent" does not point to a valid location path of a field or group.

I tried the Copy XPath to make sure I got it right, but I'm still getting the same message. Below is what I'm using with the copy XPath and the spacing you suggested. Thoughts?

Insert /parent=/my:myFields/my:Recommendations /child=/my:myFields/my:Recommendations/my:Table /count=1

Re: Insert command: Not adding rows - no error message.

Hilary Stoupa — Thu, 13 Aug 2009 18:25:51 GMT

Hi -- your command looks like it might have some spacing issues.

Insert /parent =/my:myFields/my:Table /child =/my:RepeatingInsert /count = 1

There should be a '/' before each of the arguments like parent, child and count.

Insert command: Not adding rows - no error message.

Sam Camblin — Thu, 13 Aug 2009 18:09:05 GMT

Hi,

I'm new to InfoPath and just installed qRules. I'm trying to use the Insert command to add a new row to a table when a button is clicked. I followed your instructions and example xsn file to create the below example. When I click on the button it doesn't add a row or give an error message. Thoughts?

Button's action: Set a field's value: Command = "Insert/parent = /my:myFields/my:Table/ child = /my:RepeatingInsert/count = 1"

My data source looks like this:

myFields

Table

RepeatingInsert

Name

Description

DetailID