Icon View Incident Report

Serious Serious
Reported By: Allan Brocklehurst
Reported On: 4/23/2002
For: Version 3.10 Build 1
# 1117 Editing a Record with an Active Filter Containing a TEXTSEARCH Function Causes Record to Disappear

Problem; on the C/S model. When I run a Full text edit to filter given results and display the results on a grid, I am getting everything I expect.

When I edit one of these records and scroll off the record the record disappears from the grid.

It appears that the cursor advances here 2 records.

I can retrieve the edited results by setting the filter to false then to true again.

.. None of the above occurs when I am running against a database located locally.

procedure TFormNewItemPrice.btnFilterClick(Sender: TObject);
begin
  if trim(Criteria.Text) = '' then
  begin
    MessageDlg('In Order to Filter the Table. You MUST have entered in some ' 
+
      #13 + #10 + 'Filter Criteria ie NS* or NS', mtWarning, [mbOK], 0);
    abort;
  end;
  if UseFilter = False then
  begin
    ADDM.tmpItemPrice.IndexName := '';
    lblTextFilter.Caption := 'Filter On';
    Application.ProcessMessages;
    case rgCriteria.ItemIndex of
      0:
        begin
          ADDM.tmpItemPrice.Filter := 'TEXTSEARCH("' + Criteria.Text +
            '" IN Description)';
          ADDM.tmpItemPrice.Filtered := True;
          lblTextFilter.Caption := 'Filter On';
          Application.ProcessMessages;
          UseFilter := True;
        end;
      1:
        begin
          ADDM.tmpItemPrice.Filter := 'TEXTSEARCH("' + Criteria.Text +
            '" IN DesignDesc)';
          ADDM.tmpItemPrice.Filtered := True;
          UseFilter := True;
        end;
      2:
        begin
          ADDM.tmpItemPrice.Filter := 'TEXTSEARCH("' + Criteria.Text +
            '" IN Description) OR ' +
            'TEXTSEARCH("' + Criteria.Text + '" IN DesignDesc)';
          ADDM.tmpItemPrice.Filtered := True;
          UseFilter := True;
        end;

      3:
        begin
          ADDM.tmpItemPrice.Filter := 'TEXTSEARCH("' + Criteria.Text +
            '" IN ItemMatr) ';
          ADDM.tmpItemPrice.Filtered := True;
          UseFilter := True;
        end;
    end;
  end
  else
  begin
    lblTextFilter.Caption := 'Filter Off';
    Application.ProcessMessages;
    ADDM.tmpItemPrice.Filtered := False;
    UseFilter := False;
  end;

end;



Comments Comments
This error only occurred with the remote sessions using the C/S database server.


Resolution Resolution
Fixed Problem on 4/26/2002 in version 3.11 build 1
Image