OraFAQ Forum: Forms » Non-Equi Join In Oracle Forms

Home » Developer & Programmer » Forms » Non-Equi Join In Oracle Forms (10.2.0.1.0 , ,XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Non-Equi Join In Oracle Forms [message #475591]

Thu, 16 September 2010 00:42

beginner88
Messages: 45
Registered: June 2010

Member

Hello
I want to create Non-Equi relation between EMP and Salgrade Table .
When I am writing following Query Under Relation Tab, Its giving me error message .

emp.sal between salgrade.losal and salgrade.hisal

Regards .

Report message to a moderator

Re: Non-Equi Join In Oracle Forms [message #475597 is a reply to message #475591]

Thu, 16 September 2010 01:13

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The whole query (or, at least its significant parts) could help. This is just not enough.

Saying that there's an error is useless, unless you specify which error it is (ORA-XXXXX or what?).

Report message to a moderator

Re: Non-Equi Join In Oracle Forms [message #475600 is a reply to message #475591]

Thu, 16 September 2010 01:33

beginner88
Messages: 45
Registered: June 2010

Member

FRM-15004: Error while parsing join condition

Report message to a moderator

Re: Non-Equi Join In Oracle Forms [message #475607 is a reply to message #475600]

Thu, 16 September 2010 01:54

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So this is an error while creating a master-detail relationship? I don't think that you can do that. Condition you met should be part of detail block's WHERE clause or, dynamically, created by SET_BLOCK_PROPERTY built-in, using DEFAULT_WHERE or ONETIME_WHERE.

Report message to a moderator

Previous Topic:	SHEET1 AND SHEET2 IN EXCEL
Next Topic:	Decode Function (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:22:39 CDT 2024