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: Surges Bay TAS 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: Surges Bay TAS 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 messageGo to next message
cookiemonster
Messages: 12793
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.
Re: FRM-15004: Error while parsing join condition [message #658245 is a reply to message #314316] Wed, 07 December 2016 08:41 Go to previous message
DavidOliveira
Messages: 1
Registered: December 2016
Junior Member
I had this problem now and I understood how to resover it.

First: The Data Block Master already had the triggers "ON-POPULATE-DETAILS" and "ON-CHECK-DELETE-MASTER".

I renamed them to "ON_POPULATE_DETAILS" and "ON_CHECK_DELETE_MASTER" (I put "_" instead of "-")

I created a new relationship as I intended and this time successfully.

Automatically two Triggers were created "ON-POPULATE-DETAILS" and "ON-CHECK-DELETE-MASTER".

I copied the code from these triggers to those with the name with "_" (adjustments need to be made, because there is duplicate code).

Deleted the "ON-POPULATE-DETAILS" and "ON-CHECK-DELETE-MASTER" triggers

Rename the triggers "ON_POPULATE_DETAILS" and "ON_CHECK_DELETE_MASTER" to "ON-POPULATE-DETAILS" and "ON-CHECK-DELETE-MASTER" (I put "-" instead of "_").

I hope this helps Smile
Previous Topic: When press F11 on form, showing message [merged by jd]
Next Topic: CALENDER USAGE ERROR: <FormName> navigated directly to Calender
Goto Forum:
  


Current Time: Mon Jul 24 02:21:18 CDT 2017

Total time taken to generate the page: 0.06857 seconds