You have to re-set the RecordSource as in:
Grid1.RecordSource=""
Grid1.RecordSource=<Cursorname>
This will force a rebuild of the Grid contents. As to why it works like this, others can explain better than I...
-Irv.
>Why would the Refresh() method on a grid or one of its parents not display the data in its related cursor?
>I am requerying the data from SQL server on the click of a column header to change the sort order of the grid. I am also calling the Refresh() in the headers Click() event.
>
>- I am using a private datasession
>- The RecordSource of the grid is set in the property sheet
>- Each columns' control source is set correctly
>- The grid is NOT "losing it's mind" (I know this because I can click on a different page of the parent pageframe and click back on the grids page and everything is properly displayed.)
>- I have called the Refresh() method for each of the grids parents, no luck.
>
>Does anyone have any ideas what may be happening here?
>
>BTW, I'm using VFP 7 SP1, NT 4.0 SP 6a, and SQL Server 7.
>
>Thanks in advance for any help!
>
>Don