Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and multiple parameters
Message
From
23/06/1997 10:39:25
 
 
To
23/06/1997 10:19:54
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00036190
Message ID:
00037427
Views:
34
> Still wondering though what the advantage would be to using select > statements vs views. When I tried to use a select statement for my grid, > the cells in the grid disappeared when I closed the cursor to run the > select again. I'm probably doing something wrong here, since I am used to > using views with grids, and just requery()ing. The reason for this is that the Grid is bound to a ControlSource. The Grid is 'smart' enough to detect that that ControlSource has been closed and reopened (when you SELECT into a cursor, you delete the old cursor and create a new one). This causes all of the data, and all of the formatting, disappear from the old Grid, and the Data (without formatting) will appear in the new Grid. To prevent this behaviour, use: thisgrid.ControlSource = "" SELECT .... thisgrid.ControlSource = "NewCursor" This way the Grid won't see the cursor close. /Paul
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Previous
Reply
Map
View

Click here to load this message in the networking platform