>how do you refresh a grid? I have one with the following
>WITH THISFORM.grid1
> ROWSOURCE= "Select price,quantity,noun from trans"
> ENDW
>and a click of a cmd button does the following :
>SELE TRANS
>GO TOP
>DELE next 1
>PACK
>the grid goes empty after clicking. I've tried refreshing the form too.
You may want to select into a cursor, then set your recordsource to an alias of the cursor. Then when you want to refresh the grid set the recordsource to " " then run the select statement again and reset the recordsource to the refreshed cursor. Keep in mind you will lose some property settings doing this type of refresh.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California