Solved

Multiple where clause in a master detail, using Forms Builder

Posted on 2003-11-17
5
457 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

747 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

10 Experts available now in Live!

Get 1:1 Help Now