Solved

Multiple where clause in a master detail, using Forms Builder

Posted on 2003-11-17
5
458 Views
Last Modified: 2013-12-01
Hi,
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:
WHERE ID = IDPLAYER2 OR ID = IDPLAYER3 OR ID = IDPLAYER4
Is it possible?
If so, how?
Many thanks!
Martin
0
Comment
Question by:The_Joker
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
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
0
 

Author Comment

by:The_Joker
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.
Martin
0
 
LVL 22

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

-Xmx and -Xms are the two JVM options often used to tune JVM heap size.   Here are some common mistakes made when using them:   Assume BigApp is a java class file for the below examples. 1.         Missing m, M, g or G at the end …
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…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now