[V4RB] ? about cascade deletion and many to many relationship

[Kevin Windham]

No, You are right. And from what Ruslan said, I don't have to worry 
about it deleting records from t2.

However, Maybe Ruslan could explain what is meant by this in the 
ValentinaKernel.pdf doc (VKernel-30).

CASCADE – the One record is deleted and all related with it Many 
records are
deleted also. If a Many record also have related Many records in the 
third Table(s)
then they are also deleted. In other words we have cascade deletion.

To me that means that records in t2 would be deleted. That's where I 
got my confusion from to start with.
Thanks,
Kevin


On Thursday, February 6, 2003, at 02:34  PM, Claudius Sailer wrote:

> Am Donnerstag, 06.02.03 um 20:08 Uhr schrieb Kevin Windham:
>
>> I don't think that will work. I don't have an VobjectPtr field in t1 
>> or t2, only in t12. There is nowhere to set kv_SetNull in t2. Or am I 
>> missing something?
>
> Sorry, it is possible that I missunderstood your relations.
>
> table: t12
> field1: xxx VObjectPtr.t1, kv_Cascade
> field2: xxx VObjectPtr.t2, kv_Nullable or kv_Cascade
>
> table: t1
>
> table: t2
>
> this is my understanding of your description.
>
> In both solutions (field2 is kv_Nullable or kv_Cascade) when you now 
> delete t1 then the records in t12 should be deleted too, but in t2 
> nothing should be deleted or could you explain what your relations 
> between the 3 tables?
>
> bye
>
>
> Claudius
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>