My application has a list of servers and a list of environments. The environments are made up of several servers. I don't want the user to be able to delete a server that is still a member of an environment - they should be forced to change that server in the environment to another one so that the server they are trying to delete is no longer attached to it.
I know how to write the SQL statements etc, I just need to know how to catch the delete event before it happens and then continue it or stop it depending on the outcome of the SQL query.
This post has been edited by thecornflake: 22 January 2008 - 03:38 AM