Radicore Forum: Data Dictionary » Related Tables using different names fo primary Key Columns

Home » RADICORE development » Data Dictionary » Related Tables using different names fo primary Key Columns

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

Thu, 29 October 2009 16:15

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

Senior Member

You have misunderstood how the parent relationship details in the Data Dictionary are used. They are used to construct the ON clause in JOINs when an sql SELECT statement is constructed, as documented in Using Parent Relations to construct sql JOINs.

They are not used to modify the WHERE string which is passed from one object to another as the receiving object has no idea which relationship is being used. This is documented in Different names for the same field.

This is also described in FAQ129.

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

[Updated on: Fri, 30 October 2009 09:14]

Report message to a moderator

[Message index]

		Related Tables using different names fo primary Key Columns By: dicelord on Thu, 29 October 2009 11:41
		Re: Related Tables using different names fo primary Key Columns By: AJM on Thu, 29 October 2009 16:15
		Re: Related Tables using different names fo primary Key Columns By: dicelord on Fri, 30 October 2009 09:41

Previous Topic:	Importing a Database from Oracle
Next Topic:	One subsystem with differents database names

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 22 07:36:01 EDT 2024

Total time taken to generate the page: 0.00932 seconds