Parent Record not Saving HELP!!! please

[kstans]

I'm using the following code. It's in an on click event on the child row.
The code does change the two fields on the parent row, but they do not get saved. and change back to what they were to start with.

{grid.Object}.submitGridPartRow({Grid.RowNumber});
var po={grid.Object}.getParentObject();
var sl={grid.Object}.getValue('G','Store_Location',{Grid.RowNumber});
var st={grid.Object}.getValue('G','Stock_Number',{Grid.RowNumber});
po.setValue('D','Store_Location',sl);
po.setValue('D','Stock_Number',st);
po.submitGridPart();

[GGandhi]

Re: Parent Record not Saving HELP!!! please

po.setValue('D','Store_Location',sl);
po.setValue('D','Stock_Number',st);

D refers to detail part,
if you are submitting detail then
po.submitDetailView();
if not
po.setValue('G','Store_Location',sl);
po.setValue('G','Stock_Number',st);
po.submitGridPart();
should work
if still not saving then you have to make them dirty.
take a look at the syntax in the grid component itself.

[kstans]

Re: Parent Record not Saving HELP!!! please

That did not work. The parent is a grid (one record at a time) with the child being a linked grid.

Using 'G' in the po.setValue does not change the values at all. Using 'D' changes them until the grid is refreshed.

[GGandhi]

Re: Parent Record not Saving HELP!!! please

The parent is a grid (one record at a time)

that is detail view so you have to use the example i gave for the detail view
po.submitDetailView();

{grid.Object}.submitGridPartRow({Grid.RowNumber});
var po={grid.Object}.getParentObject();
var sl={grid.Object}.getValue('G','Store_Location',{Grid.RowNumber});
var st={grid.Object}.getValue('G','Stock_Number',{Grid.RowNumber});
po.setValue('D','Store_Location',sl);
po.setValue('D','Stock_Number',st);
po.submitDetailView();

the corrected code for your example.

[kstans]

Re: Parent Record not Saving HELP!!! please

I tried the changes you sent and it doesn't even change the parent fields at all. I looked at the settings of the parent form and it is a grid.

[GGandhi]

Re: Parent Record not Saving HELP!!! please

that cannot be.
single forms are grid with detail view.
grid part gets hidden right away the detail part is shown.
i will try to post a screen cast little later.

[GGandhi]

Re: Parent Record not Saving HELP!!! please

http://screencast.com/t/wYUvrRBSgMr
here is a partial screencast it is the detail view to submit
your code originally changed the value with setValue all you need to do is submit detailview();

[GGandhi]

Re: Parent Record not Saving HELP!!! please

i corrected your code and gave you the correct ending in post #4, please tell me that did not work so i know.

[kstans]

Re: Parent Record not Saving HELP!!! please

First, thanks for your help.

I think I see my problem. I'm using a Grid, Form. It does not have a detail view.

My question is, can it be fixed using the grid I've already built. multiple tabs, several fields with special settings.

Or do I need to change it to a grid with detail view like you showed me in your screen cast.

Screenshot - 10_20_2015 , 11_04_59 AM.png

[kstans]

Re: Parent Record not Saving HELP!!! please

It is only a grid. That must be why your code in #4 didn't work.

Screenshot - 10_20_2015 , 11_19_42 AM.png

[GGandhi]

Re: Parent Record not Saving HELP!!! please

i see now, see it helps when you show what you have.
i don't think you need to revise at least for now.
the stuff about
po.setValue('D','Store_Location',sl);
po.setValue('D','Stock_Number',st);
also does not make sense
if it is grid then 'G' should work and you said it did not work, so everything led me somewhere not good.
for now you don't change anything i will try to workout a screencast in about an hour or so to see how that can be done.

[kstans]

Re: Parent Record not Saving HELP!!! please

That is why I know it has to be something real simple, that we are both somehow missing. 'G' doesn't work even though it is a grid. 'D' does work even though it is not a detail view. There is one other thing. There are two tabs on the Parent form. The fields I'm trying to change are on the first tab, and the child form is on the second tab. Would that be an issue?

[GGandhi]

Re: Parent Record not Saving HELP!!! please

{grid.Object}.submitGridPartRow({Grid.RowNumber});
var po={grid.Object}.getParentObject();
var sl={grid.Object}.getValue('G','Store_Location',{Grid.RowNumber});
var st={grid.Object}.getValue('G','Stock_Number',{Grid.RowNumber});
po.setValue('G','Store_Location',sl);
po.setValue('G','Stock_Number',st);
po.submitGridPart();

now you are referencing all to a grid part see if that works, in the meantime.

[GGandhi]

Re: Parent Record not Saving HELP!!! please

That is why I know it has to be something real simple, that we are both somehow missing. 'G' doesn't work even though it is a grid. 'D' does work even though it is not a detail view. There is one other thing. There are two tabs on the Parent form. The fields I'm trying to change are on the first tab, and the child form is on the second tab. Would that be an issue?

doubt it.

[GGandhi]

Re: Parent Record not Saving HELP!!! please

http://screencast.com/t/tVYQp0j7
take a look at this screencast.
the missing link in the problem is the row number.
for grids you need row number for search and detail you do not.
my example is just that to show you why row number is relevant.
you need to modify to your code.