Home » Developer & Programmer » Forms » FRM-15004: Error while parsing join condition
FRM-15004: Error while parsing join condition [message #314316] Wed, 16 April 2008 06:05 Go to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
I'm trying to create a relation from child block to the master block that I've created . Foreighn key is there from child to parent table.The error I get is below:

FRM-15004: Error while parsing join condition

The join condition is correct, but I'm still clueless as to what it could be.

Any clues? Is it a form bug?

Thanks and regards
Sinida P A
Re: FRM-15004: Error while parsing join condition [message #315542 is a reply to message #314316] Mon, 21 April 2008 20:56 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: FRM-15004: Error while parsing join condition [message #315568 is a reply to message #315542] Mon, 21 April 2008 22:58 Go to previous messageGo to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
No... But i put just the datablock and put the where condition in property. And put go_block and execute_query in a trigger.. So now it s running as i wish..

Regards
Sinida
Re: FRM-15004: Error while parsing join condition [message #315903 is a reply to message #315568] Wed, 23 April 2008 03:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
As a learning experience I recommend that you try the 'Relations' again. Look at the example in Online Help:
Join Condition Examples
To link a detail block to its master block through the ORDID text item that is common to both blocks, define the following join condition:

ORDID

To link the detail block to its master block through a number of text items, define the join condition as follows:

:block1.item1 = :block2.item1 AND :block1.item2 = :block2.item2

Keep in mind that the join condition specifies the relationship between the items in each block, not between the columns in the tables on which those blocks are based. Thus, the items specified must actually exist in the form for the join condition to be valid.

David
Re: FRM-15004: Error while parsing join condition [message #316004 is a reply to message #315903] Wed, 23 April 2008 08:29 Go to previous messageGo to next message
solisdeveloper
Messages: 48
Registered: March 2008
Location: Mexico
Member
It has happened to me whenever I include the name of the datablock in the join condition instead of only the fields.

i.e.
This will cause you an error:
:blk_block1.item1 = :blk_block2.item2
Instead it should be like this:
item1 = item2 

Regards
Re: FRM-15004: Error while parsing join condition [message #316239 is a reply to message #316004] Thu, 24 April 2008 06:25 Go to previous messageGo to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Thank you.. When i removed the block name, it is working in one form... But the other form still has the problem,,, But it is okay... thanks for your suggestion...

Bye
Sinida
Re: FRM-15004: Error while parsing join condition [message #505837 is a reply to message #316239] Thu, 05 May 2011 03:54 Go to previous messageGo to next message
abhijeetr_huddar
Messages: 5
Registered: February 2011
Location: mumbai
Junior Member

Please check Your database column name & form field column name.
both should be same.
i was getting error because of this.
Re: FRM-15004: Error while parsing join condition [message #505861 is a reply to message #505837] Thu, 05 May 2011 06:01 Go to previous message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
@Abhijeetr - while we appreciate you trying to help people out might I suggest you'd be better off answering more recent threads.
This one is from 2008.
Previous Topic: Tried to move Data Block Detail
Next Topic: Import text file in oracle 9i
Goto Forum:
  


Current Time: Tue Dec 06 00:05:44 CST 2016

Total time taken to generate the page: 0.08727 seconds