Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with grid displaying information from related ta
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00185263
Message ID:
00185291
Vues:
20
>I have a form that contains a pageframe with three pages. The first page contains the information for the parent record and on page three, I have a grid that displays a view of a related child table. In this grid I show a description of the record which comes from a different table that my view has been given a relationship to. I also use navigation buttons at the bottom of the form. When situated on the third page and use the "Next" and "Previous" buttons and issue a requery and a refresh from the related methods, everything works great and the descriptions of the record types display correctly, but when I am on the first page and do some manuvering and then go to the third page I see the correct records but not the correct description until I use the "Next" and then hit the "Previous" buttons.
>
>Additional information: On the activate of the third page I am also doing a requery if the parent has changed.
>
>Any help or suggestions would be much appreciated.
>
>Thanks!
>
>Dave Martin :-)

Hi Dave,
When a page activates Foxpro will automatically select the right table to refresh the grid. If you fool around with other tables in the activate event then things can run crazy. Try setting the selected table back to the parent of the grid prior to the end of the activate, or similar such stuff
HTH
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform