>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
Thanks for your reply...I'll try this...
Can u pls tell me any source or article or example through which I can use views properly...
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