Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One-to-many relationships with remote views of Oracle ta
Message
From
20/10/1998 13:59:52
 
 
To
20/10/1998 13:21:17
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00148562
Message ID:
00148579
Views:
21
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform