Information générale
Forum:
Microsoft SQL Server
Titre:
Conditional cascade delete
Hi all,
I'm trying to handle a cascading delete based on values in the child table. In other words, I want the delete to cascade if a user hasn't entered a value in a certain field of the child else disallow the delete of the parent record. Any suggestions on the best way to accomplish this? I tried to set up a delete restrict if a child record exists and then put code in the parent checking the child condition and deleting the child records if it's OK. Didn't work, I assume the trigger fires too late. Thanks.
Gary Foster
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement