Code

Re: Programmatically triggering Repeating table insert

ScottAtRVC — Fri, 01 Jul 2005 14:00:52 GMT

Hi Greg.

I seem to have hit a problem actually.

The code thisXDocument.View.ExecuteAction("xCollection::insert", "group4_6"); did the trick on the form.
With all this working, I moved the layout of the form about, which includes sections.
And from now on the ExecuteAction method is failing with the error;
The specified bstrAction value for the View.ExecuteAction call is not applicable for the current selection.

I see from MSDN;
the ExecuteAction method of the View object is used to insert data using the xCollection editing component, based on the selected context

Am i correct that selected context means, what node is currently selected on the form?
Because what confuses me about this is ... what if i have no nodes in my repeating table. How can i select this to perform the ExecuteAction?

I think to summarise i am asking if you could explain the limitations to using ExecuteAction? By this i mean, say ExecuteAction for inserting a new record in a repeating table is being triggered from the OnAfterChanged event of a text box. Can the text box be located anywhere within the form Data Source / can the text box event just call ExecuteAction / what if the repeating table has no rows?

Thanks again. Scott.

Re: Programmatically triggering Repeating table insert

ScottAtRVC — Fri, 01 Jul 2005 08:12:09 GMT

Hi Greg.

Thanks so much. thisXDocument.View.ExecuteAction("xCollection::insert", "group4_6");
Did the trick.

Cheers. Scott.

Re: Programmatically triggering Repeating table insert

Greg Collins — Thu, 30 Jun 2005 19:55:44 GMT

Look up the ExecuteAction() method in the help file. This is what you want to use. You will need to pay special attention to the portions about SelectNodes or SelectText. These are important.

If you can't locate your help files, take a look here:
http://www.infopathdev.com/downloads/free/default.aspx?s=Help%20Files

Greg Collins [InfoPath MVP]
InfoPath Dev

Programmatically triggering Repeating table insert

ScottAtRVC — Thu, 30 Jun 2005 15:58:15 GMT

Hi All.

I currently have a repeating table which only allows the user to delete a row by the button control within the row NOT the built in InfoPath repeating table functionality.

New rows are created programmatically by cloning the first row in the repeating table.

However, I have now realised this is not the best solution because should the users delete all the rows, the programmatic inserting of a new row fails because there is no row to clone.

Now using the build in InfoPath tools, a user can delete all the rows. Then press the insert new tab / button and a new row is created.

So my question is how can I programmatically mimic the insert new row InfoPath functionality?

Cheers. Scott.