Grid - Save only happening for row cursor is on

I'm struggling getting a grid to save data. It will only save changes for the row the cursor is on.

I created a form using the "Classic" category in the New Form Wizard. I selected "Build From Scratch". I created a grid on the form. When I run the form, I can only get data to save for the row my cursor is on. I can see the gold diamond icon for each row that I change. But when I click on the Save button in the toolbar. Only the row I'm currently on will save.

I created another form using the "Classic" category in the New Form Wizard. I selected "GridOnly". This form will update all rows that I change. Regardless where my cursor is.

I then compared the two forms. I can't find any differences that would cause them to save the data different.

I looked at the Collection in the Details section. I see no differences between the 2 forms.
1. I did change the Standard Options to "True" on the form created as "Build From Scratch" so that the toolbar buttons appear.
I looked at the Properties for both grids. I see no differences between the 2 forms.
I looked at the Properties for both forms. I see no differences between the 2 forms.

I'm not sure what else to look at. But there has to be some setting that causes forms created from "Build From Scratch" to have different behavior than forms created from "GridOnly". Does anyone have any suggestions on what to try next?

Find more posts tagged with

Accepted answers

All comments

Caitlin Porter

This is actually a bug that was reported by me, and was fixed in Mongoose2021.07 and Mongoose2021.08. I would suggest upgrading to fix this issue.

tdickens

That's good news.

We are using the cloud based Mongoose. Do we have to do something to upgrade to the newer version? Or does an update automatically happen? The Help About shows we are using Framework version 2021.06.00.9.

If the upgrade automatically happens, do you know when?

Thanks for your help.

Caitlin Porter

The update will happen automatically, nothing you need to do on your end. I believe it is set to upgrade in the next week or two so keep an eye out for it.

tdickens

I think there is still a bug that prevents the grid from updating rows when the Form Type = Flex.

When the Form Type = Normal, then the grid works as expected. All rows that are changed are updated. But when the Form Type = Flex, then only the row where the cursor is on is updated.

Please verify that this is a bug and it will be fixed in a later release. We are planning on using Flex forms. We will have to adjust our plans if Flex forms do not allow for updating all rows in a grid.

I've tried both StdFormSave and Collection Save. And get the same results.

Rene Bottern

Terry,

have you tried to force the Collection to think it need update(s)?

ThisForm.PrimaryIDOCollection.SetCurrentObjectModified(true);
//OR
ThisForm.PrimaryIDOCollection.SetObjectModified(1,true); //This you can use to force several records
//Then Save Collection (Should work fine with Secondary Collection as well!)
ThisForm.PrimaryIDOCollection.Save();

I have used this on Flex forms, and it works fine.

tdickens

Renee,

I tried setting the SetObjectModified to true. That caused the gold triangle to appear on all of the rows on the grid (except for the row my cursor is on). But the rows didn't save. Hopefully, Infor fixes this in the next release.

This is what I did.

public void ScriptUpdate()
{
var cntPrimary = ThisForm.PrimaryIDOCollection.GetNumEntries();

int i = 0;
while (i <= cntPrimary)
{
ThisForm.PrimaryIDOCollection.SetObjectModified(i, true);
i++;
}
ThisForm.PrimaryIDOCollection.Save();
}

Thanks for your suggestion. I'm new to Mongoose. I appreciate all of the help the people on this forum have given me.

Legacy Contributor

Have you tried to trigger the StdFormSave event and see if that works?

tdickens

Yes. I tried both the StdFormSave and Collection Save. And now I've tried it in Form Script.

Caitlin Porter

This was fixed in the latest version, however because the form definition had to be updated, it will only be fixed on new forms and still will not work on existing forms.

tdickens

Should a form created today with the New Form Wizard work? I did this today after reading your response.

New Form Wizard
1. Category = Flex
2. Wizard = Basic
3. Unit = Char
Added a Refresh button
1. StdFormRefresh
Added a Save button
1. StdFormSave
Added a Grid

A row is only saved when the cursor is on that row.

Then, I set the Collection Standard Operations to True so that I can use the Mongoose menu for Refresh and Save. Same results.

The reason we are using the Flex Layout is because our users like having the forms centered. With the left and right sections having a black background. And the middle section having a white background. They don't like having a screen full of whitespace. Is there a way to accomplish that without using the Flex Layout?

Caitlin Porter

Good question, just realized this is also not working in my environment. I followed up with the dev team about this and will let you know what they say.

Caitlin Porter

This issue will be fixed in 2021.10 for all the new form wizard forms, which will include flex forms.

Copyright © 2025 Infor. All rights reserved.