Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using views in forms
Message
From
07/12/1998 08:14:11
 
 
To
07/12/1998 07:44:11
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00164671
Message ID:
00164675
Views:
26
Hi Vinod.
>
>Currently I created 2 views, 1 parent and 1 child... But the problems I'm facing are :-
>
>1. When I move the record pointer in parent view, child view's grid is not updating...
>2. Its written in documentation that its not right to create indexes on view, then how i should relate my 2 views....
>
The way that I would handle it is to create the child view as a parameterized view. To do this, you specify something like WHERE (childTable.FoeignKey) = ?nParentyKeyValue as your filter expression. Then, in the AfterRowColChange of the grid that displays the parent table, you set the value of nParentKeyValue and REQUERY the child view.

BTW, you can create temporary indexes on views. You just have to be sure that the view is available and row buffered when you do this.

Marcia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform