🚀 go-pugleaf

Hi,
    Thanks for your help, I tried to modified my trigger as your said, but
It does not work, the error still occur. but I can execute this command
(delete Employees where EmployeeID = 1 )in commandline, It's no problem,
why?

Thanks again.

Junlin Xie

"Ivan Mihailov" <iradev@mail.vega.bg> wrote in message
news:3cdecfe4_2@dnews...
> Hi,
>
> try this:
>
> CREATE TRIGGER tg_Employees_Del ON dbo.Employees
> FOR DELETE
> AS
>
> SET NOCOUNT OFF
>
> DECLARE @EmployeeID T_ID
>
> SELECT @EmployeeID = EmployeeID FROM Deleted
>
> DELETE [dbo].[ResourceACL] WHERE EmployeeID = @EmployeeID
>
> SET NOCOUNT ON
>
> RETURN
>
>
>
> "Junlin Xie" <jlxie@yahoo.com> wrote in message news:3cd9565a_1@dnews...
> > Hi,
> >     I Have a table named 'Employees' with a triggle for deletion, I want
> to
> > delete a row from client, I trace the command using SQL Profiler, the
> > following the tracing message:
> >     sp_executesql N'DELETE FROM "CELDB".."Employees" WHERE
> > "EmployeeID"=@P1', N'@P1 int', 23
> >     EmployeeID is primary key
> >     and trigger for deletion is:
> >
> > CREATE TRIGGER tg_Employees_Del ON dbo.Employees
> > FOR DELETE
> > AS
> >
> > DECLARE @EmployeeID T_ID
> >
> > SELECT @EmployeeID = EmployeeID FROM Deleted
> >
> > DELETE [dbo].[ResourceACL] WHERE EmployeeID = @EmployeeID
> >
> > RETURN
> >
> > the error message:
> >
> > **************************
> > Error Number: -2147467259
> > Error Source: Microsoft Cursor Engine
> > Error Description: Key information is incorrect, effect multirows.
> > Error Help File:
> > Error Help Context:
> > Error SQL State:
> > Error NativeError: 1009
> >
> > but I can execute this command in commandline, It's no problem, why?
> > Please help me!!!!!
> >
> > Thank you very much!
> >
> > Junlin Xie
> >
> >
>
>