Icon View Incident Report

Serious Serious
Reported By: russell
Reported On: 6/2/2007
For: Version 1.03 Build 1
# 2352 Master-Detail Links Can Cause #601 Error During Navigation on ElevateDB Server

When session type is stLocal , This program is vary stable. But if session type is stRemote, The program will very easy to crash tables data and can not to repair them. The Error code is #601.

procedure TDMCommon.CrashData;
var i: Integer;
begin
  TblMaster.Insert;
  TblMasterMasterKey.Value := '070501';
  TblMasterFieldValue1.Value := '1';
  TblMaster.Post;

  for i:= 1 to 3 do begin
     TblDetail.Insert;
     TblDetailFieldValue1.Value := IntToStr(i);
     TblDetail.Post;
  end;

  TblMaster.Insert;
  TblMasterMasterKey.Value := '070502';
  TblMasterFieldValue1.Value := '2';
  TblMaster.Post;

  for i:= 1 to 3 do begin
     TblDetail.Insert;
     TblDetailFieldValue1.Value := IntToStr(i);
     TblDetail.Post;
  end;


  TblMaster.Insert;
  TblMasterMasterKey.Value := '070503';
  TblMasterFieldValue1.Value := '3';
  TblMaster.Post;

  for i:= 1 to 3 do begin
     TblDetail.Insert;
     TblDetailFieldValue1.Value := IntToStr(i);
     TblDetail.Post;
  end;

  TblMaster.Prior;
  TblMaster.Edit;
  TblMasterFieldValue1.Value := '2';
  TblMaster.Post;

  TblMaster.Next;

  TblDetail.Edit;
  TblDetailFieldValue1.Value := '22';
  TblDetail.Post;

  TblMaster.First;
  TblMaster.Edit;
  TblMasterFieldValue1.Value := '11';
  TblMaster.Post; 

end;

procedure TDMCommon.DataModuleCreate(Sender: TObject);
begin
  TblMaster.Open;
  TblDetail.Open;
end;

procedure TDMCommon.TblMasterBeforePost(DataSet: TDataSet);
begin
 if TblMasterMasterkey.IsNull then
    TblMasterMasterKey.Value := FormatDateTime('YYMMDD',Date); 
end;



Resolution Resolution
Fixed Problem on 6/3/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