Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized Views
Message
 
To
24/04/1998 18:46:53
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00094803
Message ID:
00094807
Views:
23
>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)

Joel, set YourView.NoDataOnLoad = .t. in Dataenvironment.
Or make your view parameter cCustNo PUBLIC variable and initialize it to " ".

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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform