🚀 go-pugleaf

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