Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » sql joins
sql joins [message #400] Tue, 14 November 2006 09:39 Go to next message
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
Re: sql joins [message #402 is a reply to message #400] Tue, 14 November 2006 09:55 Go to previous message
AJM is currently offline  AJM
Messages: 2352
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

Previous Topic: Debug application
Next Topic: New Application
Goto Forum:
  


Current Time: Mon Jul 15 06:42:24 EDT 2024

Total time taken to generate the page: 0.02913 seconds