Home » Developer & Programmer » Forms » FRM-15004 Error while parsing join condition
FRM-15004 Error while parsing join condition [message #471701] Mon, 16 August 2010 14:49 Go to next message
hanis
Messages: 5
Registered: August 2010
Junior Member
I receive a "FRM-15004 Error while parsing join condition" when attempting to create a relation between block1 (parent table) and block2 (child table). If I do a simple straight join the statement is accepted but if I use a Decode then it results in an error. Has anyone successfully used a decode or a nvl in a join statement of a relation? Thanks


Results in Error:

block1.case_id = block2.case_id and
decode(block1.employee_id, null, block1.entity_id, block1.employee_id) =
decode(block2.employee_id, null, block2.entity_id, block2.employee_id)


This join is accepted but I would like to use a decode since a record can have either a employee_id or entity_id, not both

block1.case_id = block2.case_id and
block1.employee_id = block2.employee_id and
block1.entity_id = block2.entity_id

Report message to a moderator

Re: FRM-15004 Error while parsing join condition [message #471715 is a reply to message #471701] Mon, 16 August 2010 18:43 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
That doesn't suprise me
When you create a relationship in forms it does quite a few things - mainly it creates special triggers to handle the join.
I'd be amazed if oracle coded it to cope with a join us unusual as that one.

Report message to a moderator

Previous Topic: Validation problem when updating
Next Topic: Problem with List Item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 17:15:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.