🚀 go-pugleaf

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
>
>