🚀 go-pugleaf

in right place in trigger,add set oncount on\off

jane <janez@pbtco.com> wrote in message news:3ad57172_2@dnews...
> The second:
> In SQLSERVER database , I have a trigger,
>
> create trigger AINewUser on TSUser for insert as
> begin
>     declare
> --      ��.��
>         if @UserType = 0
>           begin
>             insert into TSAppPermi
>                 select @UserID, FModuleID, FFlag, FFlagEx
>                     from TSAppPermi
>                     where FUserID = 0
>             insert into TSModuleParm
>                 select @UserID, FModuleID, FName, FType, FValue, FValueEx,
> FDesc
>                 from TSModuleParm
>                 where FUserID = 0
>         end
>        ��..
> end
>
> you know table TSAppPermi and table TSModuleParm both have more than one
> record.when I add a new record to the TADODataSet,and execute it��spost()
>  method(this can trigger the trigger),
> 1. if the table TSAppPermi have one record, the Post execute successfully.
> 2. If the table TSAppPermi have more than one record ,the ApplyUpdate
> execute erroyly. The error message Is ��update affeted more than one
>  record��.
>
> We talk about the error for a long time, we think the ADO Enginer may be
> erro. Because we use the ADO for ODBC
> Drive,the TADODataSet's Post and Refresh execute successfully.
>
> If you have good news ,don't forget to tell me.
>
>
>
>
>
>