Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One-to-many relationships with remote views of Oracle ta
Message
De
20/10/1998 13:59:52
 
 
À
20/10/1998 13:21:17
Christie Stacker
Sverdrup Naval Systems Group
Ridgecrest, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00148562
Message ID:
00148579
Vues:
22
>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
Fil
Voir

Click here to load this message in the networking platform