>hi all,
>i want to get just what i need to see at my grid exactly via this code under
>any help ,idea
>
>LOCATE FOR dat=thisform.text2.Value
>IF FOUND()
> SET FILTER TO MONTH(dat)=MONTH(thisform.text2.Value)
> thisform.grid1.Visible=.t.
> thisform.grid1.Refresh
> thisform.grid1.column7.setfocus()
>else
> =messagebox("the date not found ")
> thisform.grid1.visible=.f.
>ENDIF
> SET FILTER TO
>>thanks
1) Does it work? If it doesn't work, what happens?
2) Why does the filter not match the LOCATE condition?
3) It seems to me that setting a filter, and then immediately clearing it, won't work correctly. You should clear the filter ("SET FILTER TO") when the form closes, or at some other, later, moment.
4) Another possibility is to base the Grid on a Cursor, which you create just for the Grid.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
