Solved

Multiple where clause in a master detail, using Forms Builder

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hibernate filter not working 4 101
How to configure the log file globally for all environments? 7 128
Weblogic Logs 4 145
hibernate example issues from command prompt 10 41
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 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