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
Précédent
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