Icon View Incident Report

Serious Serious
Reported By: Michael Fullerton
Reported On: 5/30/2007
For: Version 1.03 Build 1
# 2364 Transactions with Deletes and then Inserts Can Cause Unlock Error

Within a transaction I run a DELETE query then a series of INSERTqueries. When I try to commit though I get a 1006 exception for the table involved in the query.

procedure TForm1.Button1Click(Sender: TObject);
begin
   EDBDatabase1.Open;
   EDBDatabase1.StartTransaction;
   try
    with EDBQuery1 do
      begin
      Close;
      SQL.Text:='DELETE FROM TimeHist WHERE LoginID=''Mike Fullerton'' AND StartTime '+
                'BETWEEN TIMESTAMP ''2007-05-28 00:00:00'' AND TIMESTAMP ''2007-06-03''';
      ExecSQL;
      end;
    with EDBQuery1 do
      begin
      SQL.Text:='INSERT INTO TimeHist (LoginID,ClientID,ProjectID,TaskID,StartTime,EndTime,Comments) '+
                'VALUES(''Mike Fullerton'',''Acme Piping'',''test'',''testt'', TIMESTAMP ''2007-06-01 00:00:01'', '+
                'TIMESTAMP ''2007-06-01 00:18:00'','''')';
      ExecSQL;
      SQL.Text:='INSERT INTO TimeHist (LoginID,ClientID,ProjectID,TaskID,StartTime,EndTime,Comments) '+
                'VALUES(''Mike Fullerton'',''Acme Piping'',''test'',''testt'', TIMESTAMP ''2007-06-02 00:00:01'', '+
                'TIMESTAMP ''2007-06-02 01:00:00'','''')';
      ExecSQL;
      end;
    EDBDatabase1.Commit;
    ShowMessage('Done');
  except
    on E:exception do begin
      ShowMessage(E.Message);
      EDBDatabase1.RollBack;
    end;
  end;
end;



Resolution Resolution
Fixed Problem on 5/31/2007 in version 1.04 build 1


Products Affected Products Affected
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image