>I'm using VFP3 for Mac & Windows (which I upgrade to WFP5 to run on WinNT) as the client for Oracle tables on a server. I have been unable to get my one-to-many forms to run. The VFP documentation is too vague to provide a solution. What do I need to do?
There are a few ways to do it. The simple is to set a view parameter on the child file using the related field to the parent table. Whenever you change the parent record, requery the child table... sort of like...
Parent View...
v_parent
Child View...
v_child
in the filter put...
v_child.parentid == v_parent.id
*********************
All that is left to do is requery the child view when you want to get the child records for the parent record.
BOb
PS: Of course this is not specific to Oracle, but to remote views.
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