Rows Affected problem
Posted: Mon 23 Dec 2013 17:03
Hello,
I have a problem with Rows Affected property.
With TMSSQL component the value of RowsAffected property depends from table trigger on update and delete commands. While ApplyUpdates of TMSQuery fails on delete command.
The property DMLRefresh of TMSQuery is active and insert/update commands work.
How to use TMSSQL without modify trigger to reflect rows affected not considering trigger rows?
Why TMSQuery has a different behavior?
SDAC version: 6.7.13 in Delphi XE4.
Thanks.
Alessandro
I have a problem with Rows Affected property.
With TMSSQL component the value of RowsAffected property depends from table trigger on update and delete commands. While ApplyUpdates of TMSQuery fails on delete command.
The property DMLRefresh of TMSQuery is active and insert/update commands work.
How to use TMSSQL without modify trigger to reflect rows affected not considering trigger rows?
Why TMSQuery has a different behavior?
SDAC version: 6.7.13 in Delphi XE4.
Thanks.
Alessandro