Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views and multiple parameters
Message
 
À
23/06/1997 10:19:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00036190
Message ID:
00037427
Vues:
32
> 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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform