🚀 go-pugleaf

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.