Hi!

Di you know that BeforeRowColChange event is fired each time when grid is going to be reconstructed? It happens in any case include when grid alias closed, view requeried etc. despite grid visibility, focus and grid configuration. the most amazing is that putting NODEFAULT in this event for duration of data changes prevents grid reconstruction at all!

Old method:

thisform.Grid1.RecordSource=""
... && do requery of data
thisform.Grid1.RecordSource="MyAliasWithNewData"
* than restore control sources of all columns

Now you can do following:

thisform.GridRefreshing = .T. && tell all grid controls that grid data going to be requeried
... do data requery
thisform.Refresh && or grid refresh
thisform.GridRefreshing = .F.

In the BeforeRowColChange of grid event put following:

if PEMStatus(thisform,"GridRefreshing",5) AND thisform.GridRefreshing
    nodefault
    return
endif

You can put above in the grid class.

The most fun is that this method do not require to organize restoring of the control sources of all columns.

Unfortunately, there are no way to know the reason why BeforeRowColChange event is called inside of that event to distinguish if it is called for recornstruction or movement between cells or some other actions with grid. Just use a flag for that.