Is there a trigger on the table?

-Mike

>Hi everyone
>
>I'm calling a stored procedure to delete (set the inactive flag) on some records from multiple tables. Sometimes (I hate that part) I get a sqlerror that is returning the following:
>
>

>---------------------------
>CTORE
>---------------------------
>SQL ERROR:
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
> CF: CTPREF2.PAGEFRAME1.PAGE1.XP_BTN_DELETECARD.CLICK
>---------------------------
>OK
>---------------------------
>

>
>But I'm not using a subquery, just following stored procedure:
>
>

>CREATE PROCEDURE ct_DelPrefCard
>@tiCardID int
>
>as
>SET NOCOUNT ON
>BEGIN TRANSACTION
>--Delete the actual card
>Update coSuper set isActive=0 where coSuperID=@tiCardID
>--Delete the child records
>Update coSuper2 set isActive=0 where coSuperID=@tiCardID
>set nocount off
>
>COMMIT TRANSACTION
>GO
>
>

>
>Anybody have a clue where I should start looking?
>
>Thanks
>Kirk