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

Home » RADICORE » How To » list2 not respecting list1 key
Re: list2 not respecting list1 key [message #1854 is a reply to message #1853] Sun, 16 November 2008 12:02 Go to previous messageGo to previous message
David Lee is currently offline  David Lee
Messages: 44
Registered: June 2006
Member
I believe the problem is cause by different field names in the parent and child tables. The where string passed down is "location_id = '55'", into _sqlAssembleWhere and filterWhere. However, the correct column in the inner table is FKlocation_id, and the field name location_id is valid only for the outer table. The function fails to qualify location_id with the table name, and then deletes the location_id as that field is not in the table.

This difficulty is not found if the same field name is used in both tables.

I have not stepped through to understand why it works correctly on the second record of the outer table, but trust these details are enough to allow you to reproduce and solve this problem.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Update1 problem
Next Topic: Intranet Application
Goto Forum:
  


Current Time: Sun Nov 24 05:42:29 EST 2024

Total time taken to generate the page: 0.03237 seconds