Radicore Forum: How To » override auto rdcaccount_id clause in a manually extended SQL

Home » RADICORE » How To » override auto rdcaccount_id clause in a manually extended SQL

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

Re: override auto rdcaccount_id clause in a manually extended SQL [message #2014 is a reply to message #1990]

Tue, 21 April 2009 11:07

gpatti
Messages: 287
Registered: August 2008

Senior Member

This version solves the problem as described. During testing I found another similar variation, which gave the primary key not complete error. This version solves the error but the transaction behaviour has changed.

The scenario is a LIST1 transaction using a table WITH rdcaccount_id in the primary key navigating to a LINK transaction linking to a table WITHOUT rdcaccount_id. The link table itself has rdcaccount_id and the primary key of the second table as its key.

Previously the form displayed all entries from the secondary table, with the linked rows marked as selected.

Now the form only displays the linked entries, so I've lost the ability to link and unlink entries.

I suspect the problem is as a result of the design of the keys I have used being impacted by the correction in the framework. I was linking to the outer table using ONLY rdcaccount_id because my application forces that only one entry can exist in the outer table per rdcaccount_id. I probably need to add another field as key (in fact I have, but didn't make any app changes as it worked ok).

If you think it might still be a bug in the framework please let me know. I'll hold off changing my app till you've had chance to consider it.

Graham

Report message to a moderator

[Message index]

		override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Sun, 19 April 2009 11:07
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Sun, 19 April 2009 18:36
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Sun, 19 April 2009 19:37
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Mon, 20 April 2009 05:25
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 08:51
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Mon, 20 April 2009 11:03
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 11:59
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 12:46
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 08:57
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 09:15
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 09:34
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 09:45
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 10:11
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 11:07
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Thu, 23 April 2009 04:47
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Thu, 23 April 2009 05:16

Previous Topic:	Use Messages[] in a LIST1 transaction
Next Topic:	Dynamic Task Selection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue May 05 01:30:17 EDT 2026

Total time taken to generate the page: 0.01673 seconds