Hi Lester,
I took a quick look at your code. Your Trigger code seems to be
executing but there is an semantic error. It looks clean except for an
obvious typo or a logic-bug...
Here's your code snippet
> IF @@rowcount > 0
> begin
> SELECT @deleted_specimen_id specimen_id
> FROM deleted
It seems you are aliasing "specimen_id" for the "@deleted_specimen_id"
variable or you are missing an "=" sign your code should read like
below:
IF @@rowcount > 0
begin
SELECT @deleted_specimen_id = specimen_id
FROM deleted
Try it and see if it solves your problem.
Hope this Helps,
Karthik S.
--Happy Power"Web"Building
--- "Laforce, Lester" <[EMAIL PROTECTED]> wrote:
> What is the best way to implement cascading deletes/ By implementing
> delete
> triggers????
>
> How?
>
> Can anyone suggest where to find a code example (MS SQL Server 6.5)
> or suggest another listserve where a question could be poised.
>
> We've tried the following code, it executes without error, however
> does not seem to be firing when a DELETE is executed against the
> Speciment_test table.
>
> [EMAIL PROTECTED]
> Lester LaForce
> Automated Management Systems
> Armed Forces Institute of Pathology
> Walter Reed Army Hospital
> Washington DC
>
>
> drop trigger tD_specimen_test
>
> go
> create trigger tD_specimen_test on specimen_test for DELETE as
> /* DELETE trigger on specimen_test */
> begin
>
> declare @numrows int,
> @errno int,
> @errmsg varchar(255),
> @deletecnt int,
> @deleted_specimen_id int
>
> SELECT @numrows = @@rowcount
>
> /* If no row(s) to be deleted, return */
> IF @@rowcount > 0
> begin
> SELECT @deleted_specimen_id specimen_id
> FROM deleted
>
> SELECT @deletecnt = count(*)
> FROM specimenlog_test
> WHERE specimenlog_test .specimen_id = @deleted_specimen_id
>
> IF @deletecnt > 0
> BEGIN
> DELETE FROM specimenlog_test
> WHERE specimenlog_test .specimen_id =
> @deleted_specimen_id
>
> IF @@error <> 0
> BEGIN
> /* ROLLBACK TRIGGER WITH RAISERROR 25055 'Error
> deleting Specimen Log row(s)' */
> select @errno = 30001,
> @errmsg = 'Error deleting Specimen Log row(s).'
> goto error
> END
> END
> end
> error:
> raiserror @errno @errmsg
> rollback transaction
> end
> go
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
