procedure TForm2.Button1Click(Sender: TObject);
begin
  EDBTable1.Open;
  while not EDBTable1.Eof do begin
     EDBTable1.Delete;
  end;
  //EDBTable1.Refresh;
  EDBTable1.Insert;
  EDBTable1.FieldByName('PKey').AsString  := '1';
  EDBTable1.Post;
  EDBTable1.Insert;
  EDBTable1.FieldByName('PKey').AsString := '2';
  EDBTable1.Post;
  EDBTable1.Edit;
  EDBTable1.FieldByName('PKey').AsString := '1';
  try
     EDBTable1.Post;
  except
    EDBTable1.Cancel;
  end;
end;

---

 Comments and Workarounds

---

You must update both the client application and the ElevateDB Server to 1.04 B3 in order to fix this issue. The workaround is to call the Refresh method after the Cancel method.

---

 Resolution

---

Fixed Problem on 6/20/2007 in version 1.04 build 3

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial