Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Paramaterized view in a form
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00259254
Message ID:
00259269
Views:
16
>I have a view with two parameters (Employee number and Date). In the command window I can give the parameter variables values and the view displays the appropriate records.
>
>When I add the view the the dataenvironment of a form and try to pass parameters to that form I can not figure out how to get the values to the parameter variables of the view. The grid which displays the view shows the same records no matter what values I pass to the form.
>
>I am sure I am missing something simple but if anyone could explain how to pass parameters to a view in the dataenvironment of a form, I would be very grateful.


Try setting the view property NoDataOnLoad = .t. in the dataenvironment. This will prevent the grid from displaying records before you assign values to the parameters. Use requery() to get the correct data:

cEnum = 123
dDate = date()
requery('yourview')
Previous
Reply
Map
View

Click here to load this message in the networking platform