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

Yennie at aol.com Yennie at aol.com
Thu Feb 6 14:37:18 CST 2003


Setting both t1.ptr and t2.ptr to "Cascade" should work.

When you delete a record from table t1, it will delete all of the M:M links 
in t12. It will not follow the t2.ptr to start deleting records from t2: that 
would be following the ObjectPtr in the opposite direction.

I think. =)

Brian

> >> Say I have a link table  t12 with t1.ptr and t2.ptr so I have a many
> >> to many relation between t1 and t2.
> >>
> >> Now when I delete a record  t1 I want the associated link records in
> >> t12 to be deleted, but I don't want the associated records in t2 to
> >> be deleted.
> 



More information about the Valentina mailing list