Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid refreshing
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00540286
Message ID:
00540307
Views:
17
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform