>Fabio,
>
>
"Beserk" in what sense?
>a change in the SELECT ORDER not expected to affect the grid.>
>That is what I also thought. Any change I make into ANY of the segments in SELECT, ORDER, WHERE will result in my grid going beserk.
>
>A little googling made me find this (which works like a charm):
>
>
>
>* previous to this, create a temp cursor with the same structure as the CA cursors in INIT of form and build up your grid
>
>ThisForm.myGrid.RecordSource = "myTempCursor"
>
>myCursor.CursorFill()
>
>ThisForm.myGrid.RecordSource = "myCursor"
>
>
This is by design.
CursorFill destroy the old Alias.
When the Grid.RecordSource become empty or the dbf is destroyed,
VFP reset the grid structure ( look in Recorsource help )
try this:
ThisForm.myGrid.RecordSource = " "
myCursor.CursorFill()
ThisForm.myGrid.RecordSource = "myCursor"