kRestrict +kCascade type link
Ruslan Zasukhin
sunshine at public.kherson.ua
Mon May 30 21:47:45 CDT 2005
On 5/30/05 9:42 PM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:
>> On the other hand ... May be you have discover new idea.
>> and may be in fact M : M link CASCADE should work
>> exactly as you describe?!
>
> Again, using my example:
>
>> t1rec1 <-> t2recA
>> t1rec1 <-> t2recB
>> t1rec2 <-> t2recB
>
> I would think that cascade would lead to this result:
>
> delete t1rec1 -> deletes t2recA and deletes t2recB -> deletes t1rec2
>
> In other words, deleting t1rec1 would result in an empty database. No?
100% no.
Here is important to think who is owner.
In your example Table1 is Owner.
So Table2 cannot delete records from Table1.
CASCADE works into one direction only
> (I tried to test this by creating a quick database in Vstudio, but it kept
> crashing when I tried to create the BinaryLink.)
Please report this into Mantis
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
More information about the Valentina
mailing list