Radicore Forum: Bug Reports » Losing $where when fixed selection is not present

Home » RADICORE development » Bug Reports » Losing $where when fixed selection is not present

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

Re: Losing $where when fixed selection is not present [message #2287 is a reply to message #2242]

Thu, 27 August 2009 11:24

gpatti
Messages: 283
Registered: August 2008

Senior Member

I've now spent some time trying to debug what is happening and I think it is as follows:

I move from an outer table to an inner table using a LIST2 transaction and $where at this point contains the primary key of the outer table row, such that all the inner table rows are selected as expected.

Now, I have two choices:

1. I press a navigation button which gives me a MULTI2 transaction based on the same inner table - having NOT made any selections. This works correctly, and $where still contains the primary key from the outer table.

2. I press a navigation button which gives me a MULTI2 transaction based on the same inner table - having made a selection. Now I find that $where is being replaced by $selection at line 2467 of std.table.class.inc because $selection is not empty. It now doesn't contain the primary key of the outer table resulting in the 'primary key not complete error'.

Maybe I need to do something to handle this?

Graham

Report message to a moderator

[Message index]

		Losing $where when fixed selection is not present By: gpatti on Mon, 10 August 2009 07:39
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 10 August 2009 10:49
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 10 August 2009 11:33
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 10 August 2009 11:29
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 10 August 2009 11:57
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 06:57
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 08:49
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 09:20
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 09:39
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 09:36
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 09:55
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 11:09
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 11:37
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 13:15
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 13:59
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 15:15
		Re: Losing $where when fixed selection is not present By: gpatti on Mon, 17 August 2009 17:26
		Re: Losing $where when fixed selection is not present By: AJM on Mon, 17 August 2009 18:38
		Re: Losing $where when fixed selection is not present By: gpatti on Tue, 18 August 2009 04:58
		Re: Losing $where when fixed selection is not present By: AJM on Tue, 18 August 2009 05:17
		Re: Losing $where when fixed selection is not present By: gpatti on Tue, 18 August 2009 05:32
		Re: Losing $where when fixed selection is not present By: AJM on Tue, 18 August 2009 06:24
		Re: Losing $where when fixed selection is not present By: gpatti on Thu, 27 August 2009 11:24
		Re: Losing $where when fixed selection is not present By: AJM on Thu, 27 August 2009 11:55
		Re: Losing $where when fixed selection is not present By: gpatti on Thu, 27 August 2009 12:23

Previous Topic:	isnull clause being filtered out of $where with scriptNext()
Next Topic:	Recover Password is encrypted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Sep 16 17:52:30 EDT 2025

Total time taken to generate the page: 0.01273 seconds