View Incident Report

Serious

Reported By: Jon Lloyd Duerdoth
Reported On: 1/18/2001
For: Version 2.06 Build 1

# 715 RowsAffected Property Incorrect For INSERT, UPDATE, or DELETE Queries that are Implictly Rolled Back

If I use the following code to add records from N to N2 where there is a duplicate key the implicit transaction is rolled back (I guess that's what's supposed to happen) However, the RowsAffected still equals the number. of rows "added" up to the error. If the transaction is rolled back shouldn't the RowsAffected be 0?

   SQLstr := 'insert into "N2"  select * from "N"  ';
   with dbiqQuery do begin
      SQL.clear;
      SQLscript.Clear;
      SQL.add(SQLstr);
      try
         ExecSQL;
      except
         on e: exception do begin
            showmessage(e.message);
            end;
         end;
      showmessage(IntToStr(RowsAffected));
      close;
      end;

Resolution

Fixed Problem on 1/20/2001 in version 2.07 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap