[V4MD] Object Pointers

Daniel Crowder daniel at monumental-i.com
Sat Aug 7 14:23:49 CDT 2004


Thanks Ruslan, this is my first Valentina-based project - so forgive the 
newbie questions!

>Yes of course.
>
>Just set both ObjectPtr to have CASCADE deletion.
>Then Valentina will a automatically delete records in Link table.
>
>  
>
Just to confirm: When the ObjectPtr field type is set to CASCADE the 
following would happen:

I have a product database record. It has a CATEGORY_ID that is an 
ObjectPTR (Cascade delete on) that points to a particular record in a 
CATEGORIES table. If I delete the category record it points to - the 
entire product record is deleted since it contains a cascade delete 
enabled ObjectPtr.

-CONVERSELY-

Using the same scenario as above: if the same ObjectPTR was set to 
restrict and NOT cascade. When I tried to delete that particular record 
in CATEGORIES it would have thrown an error because of the dependency 
and not delete the category record as a result.



More information about the Valentina mailing list