Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Populating a Grid with a View
Message
De
04/12/1997 10:30:05
 
 
À
04/12/1997 10:25:04
Jeff Tucker
Mackinac Center For Public Policy
Midland, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00063772
Message ID:
00063791
Vues:
60
>>>(VFP 5.0)
>>>
>>>I have three forms.
>>>
>>>(They probably should be a formset, but I am sure exactly how to do that or when I should do that.)
>>>
>>>The first form is password form, which passes the name of the user and userID to the second form.
>>>
>>>The second form receives the name and requeries a view to popluate a grid with "Summary Information." If the user would like to see "Daily Information" they select the third form and pass their name and userID to the third form.
>>>
>>>The third form recieves the name and userID and requeries a view to populate a grid with the "Daily Information."
>>>
>>>Now the problem is this.
>>>
>>>The grid in the second form sporadically shows data. When the form loads the first time, the data flashes for a split second and then dissappears. I know that the view has content, but despite efforts to requery and refresh the view and grid, nothing appears. Oddly enough, if I open the view manually and run it and then, with it in the memory, run the forms, the data for form two will appear and change based on which user information is passed.
>>>
>>>Because the third form worked fine, I switched the order of the forms. I put form three in the second position and form two in the third position. Once I had done so, form three had the problem and form two worked fine. This indicates to me that there is something peculiar about this second position.
>>>
>>>If you have any advice, I would greatly appreciate it.
>>>
>>>Jeff
>>
>>It might be irrelevant, but just few points:
>>1. Password form usually is used as first app form (modal) and if it's OK, than it disappeares and app interface comes up.
>>2. It's normal instead of using separate parameter-entry and grid form, use one form with two pages.
>>In regard to your problem, I guess you have difficulties with form referencing which prevents you from issuing Grid.Refresh from another form.
>
>Those are some good points. I will give the two page idea a try.
>
>You may be right about form referencing, but I do not think so. Below is the code I use on form two to refresh the grid.
>
>wait window cpassid + cpassname (This proves that the id and name actually exist and are passed)
>thisform.refresh
>results = requery("vtotalgrid")
>thisform.grdTotal.refresh
>
>Am I missing something here?

No, it's OK. I just imagined, probably wrong, that you were going to update grid from another form.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform