Re: [SQL] Need help creating a BEFORE DELETE trigger

2003-06-30 Thread Rod Taylor
> The problem I'm looking at is: could this cause a recursion problem, where the > cascading deletion will try to cause the whole thing to cascade again? How It will only be able to delete the row (and cascade) once per row. The second time it tries to find the row, the row won't exist anymore.

[SQL] Need help creating a BEFORE DELETE trigger

2003-06-30 Thread Michael A Nachbaur
Hello everyone, I'm creating two database tables that will be used to cache the results of a search. Basically, when a search is initiated, an entry will be created in the "Search" table that represents the search, and a single entry will be created in a child table "SearchResults" for every r