Question

Asked:
Asked By:
Dec 31 2008   4:59 PM GMT
Kobi   5 pts.

querying detail records


Oracle 6i, Oracle Forms, Oracle Forms 6i

how do I query a detail record in a master-detail Oracle 6i form

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



I'm not sure if I understand correctly your question.

You need to create a relation between the master block and the detail block, and this way, when you execute a query on the master block, the detail block is automatically queried.

If such relation already exists, and what you want is to be able to query a specific detail record, you just need to navigate to any queriable item in the detail block, and execute a query.

Hope this helps.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register