Multiple where clause in a master detail, using Forms Builder

Posted on 2003-11-17
Last Modified: 2013-12-01
I'm developing an application with Forms builder 9i.  I have a master-detail relation and I need to have a multiple where clause.  Something like:
Is it possible?
If so, how?
Many thanks!
Question by:The_Joker
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 22

Accepted Solution

Helena Marková earned 25 total points
ID: 9769292
You have to modify join condition property of relation.

- compound joins can be entered in the following format:

block1.item1 = block2.item1 AND block1.item2 = block2.item2

Author Comment

ID: 9772211
Like ou you said, block1.item1 = block2.item1 AND block1.item2 = block2.item2
it works.
But I need to have an OR not an AND to join togheter
I have a 0:n, 0:n relation between two tables without an intermediate table between
I have put the primary key of one table in the other and there can be up to 4 foreign keys coming from the first table.
It's hard to explain...I don't know if you understand!!
Well thanks.
LVL 22

Expert Comment

by:Helena Marková
ID: 9776761
Maybe block2 can be based on a view ...

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
java.util.concurrent.Callable way of creating threads 2 112
how to pass command line arguments to Jetty 10 189
Running Java application as ordinary user 24 101
Setup GlassFish 4 34
Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question