[Solved] Update single row in GridControl from subform

[mic45267]

I have a datatable with many properties. I have created a main form using a GridControl to display only the main properties and a subform displaying all other properties for selected data (main form) record.

The subform and main form have been linked using the master/slave field.

I have expected, that if I change a property in the main or subform, the content of the other form is automatically refreshed.(like in MS Access SplitView). But this is not the case.

Now I have used "Before Record action " event to reload the main/subform. When I do this on the table control, the complete table is reloaded and I loose focus on the currently selected row. This is not convenient for the user.

How can I update a single/selected row of the gridcontrol?

[Arineckaig]

I have expected, that if I change a property in the main or subform, the content of the other form is automatically refreshed.(like in MS Access SplitView). But this is not the case.

The Base GUI will automatically update the content of a subform whenever the record pointer is moved in the main form to which the subform(s) is linked. Hence perhaps the simplest means to update a subform linked to a main form containing a grid from control is to select a different record in the grid and then select back again the original record - using either the mouse or the up and down arrow keys.

If this type of double selection is considered cumbersome, add a command button to the subform whose action property is set as "Refresh Form". Though that command button is contained in the subform it can always be located on the form document to appear as part of the main form.

It is essentially a matter of personal judgement which method may come easier for the user.

[mic45267]

I don't want to do the manual approach. When I do a refresh of the main form (calling "reload") the complete table is loaded and the first row in the table is selected. My intention is only to refresh the currently selected row.

[Villeroy]

Code: Select all

sub FormAfterRecordAction(e)
frm = e.Source
if frm.isFirst() then
  frm.next()
  frm.previous()
else
  frm.previous()
  frm.next()
endif
end sub

[Arineckaig]

mic45267 stated:

Code: Select all

When I do a refresh of the main form (calling "reload") the complete table is loaded and the first row in the table is selected. My intention is only to refresh the currently selected row.

Merely for clarity, the main form is not reloaded when its record pointer is moved: only the old record is saved (if changed) and the new linked subform loaded.

Villeroy's macro solution is wholly suitable and reliable. Form change events, however, to trigger macros can sometimes have unexpected results: for example, the Before Record Action event is known to fire twice. That may or may not matter, but developing AOO macros is more complex by comparison with those so readily supplied by MS Access. Hence the suggestion that it is generally easier and safer to avoid AOO macro solutions unless specifically required.

[mic45267]

Thank you for your input.

Based upon the information from Villeroy, I am now using refreshRow of the form object.

for the Mainform:

Code: Select all

anEvent.Source.getByName("SubForm").refreshRow()

for the Subform:

Code: Select all

anEvent.Source.parent.refreshRow()