?
Solved

Multiple where clause in a master detail, using Forms Builder

Posted on 2003-11-17
5
Medium Priority
?
464 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
[X]
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
5 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 100 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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

762 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