updating grid values in background

mathieu jolivet

Hi.





We are currently working on a project using Coresuite Customize, and we face a really annoying problem.

On an order form, When I update the itemcode field into the grid, I must also update other values (for example weight, unit price, some custom fields). The problem is that when I do this, it acts as if I clicked on those fields and updated the value manually. Therefore, I see the right side of the grid, and Im not on the column next to itemcode anymore (as it should be on a normal SAP use, without any modification).



What I want to do is :

I go out of the itemcode (using tab, or clicking somewhere else)

Some values in other columns of the current row are updated

The cursor still stays on the column it was supposed to be, either the column next to itemcode (if I typed tab) or the column/field where I clicked.



I suppose that the easier way to achieve this, is to update the fields in the background, but I didnt see anything that allow me to do that.



Can you tell me how I can do it?



Thanks a lot.



Have a good day

Paolo Manfrin

Hi Mathieu,

have you tried setting up directly the values in the datasource linked to the matrix insted of using the SetValue method?



Another workaround might be the following:



Freeze form

Set all values

Put focus back on original item

Defreeze



hth

cheers,

paolo

DREAN Sébastien

Hi Paolo,



Do you know what method we could use in order to do this? We have found "FlushToDatasource" and "LoadFromDatasource", but those two methods do not seem accurate.



Thanks