Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local Views and Relationships
Message
 
To
17/08/1998 12:42:52
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00127203
Message ID:
00127482
Views:
38
>Since I have no experience with parameterized views, could you give me a quick tutorial? I consulted the VFP Documentation and I'm still not clear what to do. I know that I can modify a view, and open view parameters under the Query menu, but then I'm lost as to what to do. Thanks for your help.
Rixon,

In the Filter page of the view designer you use a ? as the first character of the Example followed by a variable name. Then in your fomr you set the view's NoDataOnLoad property to .T. so it won't run the query when the fomr loads. In the form code, wehreever you need to, you create the variable and assign it a value then ReQuery("TheView") to get the records.

For parent child views the child view would have a filter of;
 Parent.ID = ?lcParentID
Then in your form code, when you move the parent record you would;
 lcParentID = Parent.ID
 Requery("ChildView")
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform