Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Populating a grid-on the fly?
Message
 
À
25/02/1998 17:50:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00081221
Message ID:
00081223
Vues:
22
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform