>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=""
>...
>thisform.Grid1.RecordSource="MyAliasWithNewData"
>* than restore control sources of all columns
>
>
>Now you can do following:
>
>
>thisform.GridRefreshing = .T.
>... do data requery
>thisform.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.
Great tip, Vlad!
>
>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.
If it's not broken, fix it until it is.
My Blog