Radicore Forum: Transaction Patterns » Delete2 deletes the wrong records... where's my error?

Home » RADICORE development » Transaction Patterns » Delete2 deletes the wrong records... where's my error?

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

Re: Delete2 deletes the wrong records... where's my error? [message #1203 is a reply to message #1202]

Sat, 29 December 2007 04:48

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If you have created a new version of this MULTI2 transaction with table B as the outer entity and X as the inner entity (where X performs an internal JOIN to table A) then by definition you are selecting a single occurrence of table B and showing those occurrences on table X which link to table A. This is why b_id remains constant and a_id keeps changing.

If you want a_id to remain constant then table A must be defined as the outer entity.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Delete2 deletes the wrong records... where's my error? By: ikatz on Fri, 28 December 2007 18:05
		Re: Delete2 deletes the wrong records... where's my error? By: AJM on Sat, 29 December 2007 04:48
		Re: Delete2 deletes the wrong records... where's my error? By: ikatz on Mon, 31 December 2007 12:50
		Re: Delete2 deletes the wrong records... where's my error? By: AJM on Mon, 31 December 2007 13:31
		Re: Delete2 deletes the wrong records... where's my error? By: ikatz on Wed, 02 January 2008 14:51
		Re: Delete2 deletes the wrong records... where's my error? By: AJM on Wed, 02 January 2008 15:29
		Re: Delete2 deletes the wrong records... where's my error? By: ikatz on Fri, 04 January 2008 17:33
		Re: Delete2 deletes the wrong records... where's my error? By: AJM on Fri, 04 January 2008 18:01
		Re: Delete2 deletes the wrong records... where's my error? By: ikatz on Wed, 09 January 2008 15:51
		Re: Delete2 deletes the wrong records... where's my error? By: AJM on Wed, 09 January 2008 16:49
		Re: Delete2 deletes the wrong records... where's my error? By: ikatz on Wed, 09 January 2008 20:05
		Re: Delete2 deletes the wrong records... where's my error? By: AJM on Thu, 10 January 2008 05:07

Previous Topic:	POPUP transaction probelm
Next Topic:	can't get _cm_popupReturn to execute

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Jun 25 16:12:36 EDT 2025

Total time taken to generate the page: 0.01594 seconds