grid field won't update

(0) Share

Report

Posted on by Community Member

Dear All,

I have a field called Note on an extension table of SalesTable, SalesTable_DIE. So this field has 1 value for 1 SO. I also have a form, the Picking List Jornal (Accounts receivable/Common/Sales orders/All sales orders, Pick and pack tab, Journals group, Picking list). This shows multiple lines for the same SO. On these lines I want to show the value of the aforementioned Note field. 2072.update.png

It works up to this point, but when I edit the Note field on a certain line, it doesn't update on the others - as You can see on the screenshot, even though the Note value changes on the table and also the form datasource. It only updates if I press F5. I tried multiple things all to no avail.

Thanks for the help.

Gabor

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Override the write() method on the formdatasource, and call a FormDataSource_ds.research(true) to refresh the records (after saving the current value by calling super()) on the line, while also retaining the current cursor position.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply. My write() looks like this now but still does'nt work.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Finally solved it. The problem was, that the fields on the lines in the grid were from WMSPickingRoute table, but the Note field was from an extension table for SalesTable (both being datasources on the form). Every method I tried to call I did it for the extension table, but I had to call them for the other one. So in the end WMSPickingRoute_DS.executeQuery() worked for me.

Was this reply helpful? Yes No