Radicore Forum: How To » Multiple parent/child relations between 2 tables

Home » RADICORE » How To » Multiple parent/child relations between 2 tables

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

Re: Multiple parent/child relations between 2 tables [message #1347 is a reply to message #1346]

Fri, 23 May 2008 19:19

AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK

Senior Member

I see that between the two tables you have various different versions of task_id, namely:
- task_id
- parent_task_id
- blocked_task_id
- waiting_task_id

How are you converting 'task_id' to any of the other values? When passing context between database objects there is no automatic conversion of column names, so you will have to do it manually.

If you look in the menu system at the relationships between the MNU_TASK and MNU_MENU tables you will see that the column name 'task_id' has to be translated to either 'menu_id' or 'task_id_jnr', and this is done by custom code as it cannot be done automatically by the framework.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Multiple parent/child relations between 2 tables By: ikatz on Fri, 23 May 2008 16:45
		Re: Multiple parent/child relations between 2 tables By: AJM on Fri, 23 May 2008 19:19
		Re: Multiple parent/child relations between 2 tables By: ikatz on Thu, 29 May 2008 14:44
		Re: Multiple parent/child relations between 2 tables By: AJM on Thu, 29 May 2008 15:15
		Re: Multiple parent/child relations between 2 tables By: ikatz on Thu, 29 May 2008 18:53
		Re: Multiple parent/child relations between 2 tables By: AJM on Thu, 29 May 2008 19:08

Previous Topic:	How do you deploy your app?
Next Topic:	Use update2 pattern when I have two tables parent->child

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 08 22:31:34 EST 2024

Total time taken to generate the page: 0.00995 seconds