Radicore Forum: How To

Home » RADICORE » How To » sql joins

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

sql joins [message #400]

Tue, 14 November 2006 09:39

salamsy
Messages: 18
Registered: October 2006
Location: Dakar

Junior Member

When trying to display field from related table I found the sql LEFT JOIN very useful at picking description field in a LIST2 screens.
But when I try to access a related row using a part of a primary key (a relation table LIST1, used for search purpose), the LEFT JOIN statement is not working.
Any idea ? Do you have an extended set of sql statements ?

Abdou Salam

Report message to a moderator

Re: sql joins [message #402 is a reply to message #400]

Tue, 14 November 2006 09:55

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

Senior Member

The Radicore framework can only automatically construct sql queries containing JOINs when the relevant relationship details have been entered into the data dictionary AND all the foreign key fields are present. For any other situation you will have to construct the sql query manually in your code. An example is given in http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq08

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

Report message to a moderator

Previous Topic:	Debug application
Next Topic:	New Application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 12:13:38 EST 2024

Total time taken to generate the page: 0.01021 seconds