Radicore Forum: How To » list2 not respecting list1 key

Home » RADICORE » How To » list2 not respecting list1 key

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

Re: list2 not respecting list1 key [message #1854 is a reply to message #1853]

Sun, 16 November 2008 12:02

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.

Report message to a moderator

[Message index]

		list2 not respecting list1 key By: rgervais on Fri, 30 March 2007 09:56
		Re: list2 not respecting list1 key By: AJM on Fri, 30 March 2007 10:45
		Re: list2 not respecting list1 key By: rgervais on Fri, 30 March 2007 13:12
		Re: list2 not respecting list1 key By: AJM on Fri, 30 March 2007 13:45
		Re: list2 not respecting list1 key By: rgervais on Fri, 30 March 2007 16:33
		Re: list2 not respecting list1 key By: AJM on Fri, 30 March 2007 16:59
		Re: list2 not respecting list1 key By: rgervais on Sat, 31 March 2007 07:54
		Re: list2 not respecting list1 key By: AJM on Sat, 31 March 2007 08:22
		Re: list2 not respecting list1 key By: AJM on Sat, 31 March 2007 10:46
		Re: list2 not respecting list1 key By: rgervais on Sun, 01 April 2007 20:44
		Re: list2 not respecting list1 key By: David Lee on Sat, 15 November 2008 07:32
		Re: list2 not respecting list1 key By: AJM on Sat, 15 November 2008 09:36
		Re: list2 not respecting list1 key By: David Lee on Sun, 16 November 2008 12:02
		Re: list2 not respecting list1 key By: AJM on Sun, 16 November 2008 12:22
		Re: list2 not respecting list1 key By: AJM on Sun, 19 July 2009 06:23

Previous Topic:	Update1 problem
Next Topic:	Intranet Application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 21 06:25:02 EDT 2026

Total time taken to generate the page: 0.07491 seconds