Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Populating a grid-on the fly?
Message
 
To
25/02/1998 17:50:30
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00081221
Message ID:
00081223
Views:
18
>we have a screen in vfp5 that we want to have a grid and a button under it. When the user pushes the button, a sql statement executes and the grid should fill with data. We see the data is pulled in on the status line but it does not populate the grid. If we manually run the sql before the screen is run, the grid is populated....Refresh doesn't seem to get it. Am I missing something here? I thought REQUERY was the answer but it does not seem to be for grids.

Ed, when you re-run SQL your grid looses RecordSource. You have to reset record
source after SOL, but in general it is better to use a view as grid.RecordSource, REQUERY(), and grid.Refresh()

HTH,

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform