Table A has
 Detail Table(s) B has
   Detail Table(s) C

In TableA_BeforeDelete I start a restricted transaction to cascade delete rows in B tables.
In TableB_BeforeDelete I start a restricted transaction to cascade delete rows in C tables.

The problem is in TableB_BeforeDelete I can't know there is already an active transaction (same thing as InTransaction at TEDBDatabase
component). Since rows in Table(s) C can be deleted due both TableA or TableB row deletion, how can be it done?

Thanks!

Tiago


Can rows in table B be deleted without deleting rows in table A and can rows in table C be deleted without deleting rows in table B?

Roy Lambert [Team Elevate]

Roy,

>Can rows in table B be deleted without deleting rows in table A and can rows in table C be deleted without deleting rows in table B?

It's a true cascade. If you delete A then B and C must be deleted. If you delete B then C must be deleted. If you delete C then nothing more
occurs. And of course, deleting B don't affects A and deleting C don't affects A nor B.

Tiago,

<< The problem is in TableB_BeforeDelete I can't know there is already an
active transaction (same thing as InTransaction at TEDBDatabase component).
Since rows in Table(s) C can be deleted due both TableA or TableB row
deletion, how can be it done? >>

Right now you have to attempt the START TRANSACTION and catch the exception
using an EXCEPTION block.  I've got an INTRANSACTION() function on the list
for 2.03 to resolve this.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<  I've got an INTRANSACTION() function on the list
for 2.03 to resolve this.>>

This will definitely be the solution!

--
Tim Young
Elevate Software
www.elevatesoft.com