Information générale
Titre:
Parameterized Views
I have a form with a page frame and 5 pages.
The first page contains a customer grid where the user picks a customer.
The next 4 pages contain a grid of child data from 4 different FPD data tables. Each of those grids is based on a paramterized view which gets requeried each time the user picks a different customer.
The parameter is "cCustno" for all 4 views.
Works real nice. except for this: If I put the 4 views in the data environment, I cannot figure out how to avoid the form asking the user for a cCustno input at the start of each execution (in the view parameter dialog box). I have tried putting cCustno=whatever in several places, but the form never sees it when it loads up the data environment. Once past the initializing of cCustno, all subsequent clicks on the 4 "child" view pages work fine, with no further view parameter dialog box.
So, I tried taking the views out of the DE, but that results in the 4 child grids not displaying any data at all for some reason. I have verified that the requery was successful by placing a browse command right after the requery, but the grid will not display the data unless I have the views included in the DE.
I have tried so many combinations of trials, that it's possible my difficulties are dependent on something other than the above info. I seem to recall that early in my testing, I was able to display the views in their grids without the views being in the DE, but somehwere during the day, I seem to have lost that ability. I have experimented with REQUERY, USE, SELECT, etc at different places in my code. I can't seem to get a stable set of conditions which produce the desired result, which is to avoid the initial parameter dialog, and still have the ability to display the data.
Thanks, once again. Joel. (just signed on as a premium member... awaiting call from UT)
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement