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"
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.
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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.