>>>>>For design-time see
>>>>>
Re: Changing grid's RowSource in Design-time Thread #
674623 Message #
674846>>>>>
>>>>>And I just found that I forgot to add attribution in my code and was trying to find this thread by different name. Shame on me.
>>>>>
>>>>>For run-time I either use safe select approach or CA with CursorRefresh()
>>>>
>>>>Thanks, Naomi, but there;'s a simpler soln. I'm after
>>>
>>>What can be simpler than zapping a cursor and appending into it from the temp one?
>>
>>This:
>>
>>thisform.grid.recordsource = ""
>>
>>* Create new cursor...
>>
>>thisform.grid.recordsource = cursor
>
>And then you have to add a ton of code to get the grid to behave like it used to do? No this is NOT the way, Terry. But this is:
>
>Select whatever into cursor curtemp
>Select Gridcursor
>zap
>appe from dbf('curtemp')
>yourgrid.refresh()
Thanks Tore
This has raised some intersting issues:
1. The initial dummy select - doesn't that belong in a different method? Otherwise it would be getting created again, anyway, every time you call the method to refresh the grid with the newly selected data?
2. You talk about the extra code necessary (presumably to "shape" the grid.) but where does the grid formatting, and field-to-grid column allocation happen, if you don't select the data in the order in which it should appear on the grid.
AFAIC see, you have to do that anyway.
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.