Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery a 6.0 Grid
Message
From
21/03/2000 03:57:07
 
 
To
20/03/2000 13:30:57
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00347821
Message ID:
00348228
Views:
29
Hi David.

>> Is there some way to requery a 6.0 grid without having to re-define grid properies? <<

The easiest way to do this is to define a parameterized view and use that as the RecordSource for your grid. Thn, when you have to change the grid's contents, you just Requery() the view with a different paramter.

Another technique that I use is what I call a "safe" select. I define an updateable cursor in the form load and use that as the RecordSource of the grid. Then, when I want to requery the grid's contents, I zap it's RecordSource, do a SELECT into a temporary cursor, and append from the temporary cursor into the grid's RecordSource. Zapping the grid's RecordSource will not reset the grid because it does not close the RecordSource.

Marcia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform