Icon View Incident Report

Serious Serious
Reported By: Michael Haralabos
Reported On: 3/12/2002
For: Version 3.07 Build 1
# 1058 Modifying a Field in a Remote Live Result Set that is Used for Another Calculated Field Can Cause AV

Example below:

{ This causes AV on remote connections }

procedure TForm1.NormalExecute(Sender: TObject);
begin
  with Query do
  begin

    with Sql do
    begin
      Clear;
      Add('Select RECORDID, NAME, START,  FINISH, ' +
          '((FINISH - START) / 3600000) as HOURS');
      Add('From Data');
      Add('Where CAST(START AS DATE) Between :StartDate and :EndDate');

      Params[0].AsDate := Date -1;
      Params[1].AsDate := Date;
    end;

    Open;
  end;
end;



Comments Comments
Problem was with calculated fields not being transported down to the client from the server properly. If you have this problem then you must update both the client and server to 3.08 to fix this problem.


Resolution Resolution
Fixed Problem on 3/12/2002 in version 3.08 build 1
Image