Re: [GENERAL] Can't delete - Need cascading update instead

2005-03-09 Thread Richard Huxton
Adam Tomjack wrote: For various reasons, I can't actually delete records from my database. Instead, I have a boolean 'active' field for each table. I need to implement something like cascading delete, but instead of deleting, I need to set active=false. I've googled and haven't found a solutio

[GENERAL] Can't delete - Need cascading update instead

2005-03-08 Thread Adam Tomjack
For various reasons, I can't actually delete records from my database. Instead, I have a boolean 'active' field for each table. I need to implement something like cascading delete, but instead of deleting, I need to set active=false. I've googled and haven't found a solution. I had two ideas,