Thank you for the example illustrating the "scenario"
>
>Just take is short hand for "business scenario".
>If a record looses its logical parent, it often has lost its "reason to live".
>If an order is cancelled before sending, reassigning order items to an "emptyParent"
>might create more trouble down the line. It must make "biz sense" to keep them instead
>of deleting them. If it is not done for "biz reasons" but to reutilze disc space,
>a logicla delete flag or status field IMHO is better
>
>regards
>
>thomas
>
>>>Hi Dmitry,
>>>
>>>sorry for that - UC is our short hand for "Use Case"
>>>Hope it makes sense now ;-)
>>>
>>>regards
>>>
>>>thomas
>>>
>>>
>>>>>
>>>>>If your UC needs the records in the child table to remain - yes -
>>>>>but I'd ask first for written order/description of the UC, as I prefer cascading deletes ;-)
>>>>>
>>>>>regards
>>>>>
>>>>>thomas
>>>>
>>>>Sorry but I don't know what is the "UC". Could you please explain.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham