sess1.Active := False;
  sess2.Active := False;
  db1.Directory := ExtractFilePath(Application.ExeName);
  db2.Directory := ExtractFilePath(Application.ExeName);

  tblTemp1.EmptyTable;
  tblTemp1.Open;
  tblTemp2.Open;
  tblTemp1.Filtered := False;
  tblTemp2.Filtered := False;

  tblTemp1.Append;
  tblTemp1Keywords.Value := 'kw1';
  tblTemp1.Post;

  tblTemp1.Append;
  tblTemp1Keywords.Value := 'kw2';
  tblTemp1.Post;

  tblTemp1.Append;
  tblTemp1Keywords.Value := 'kw3';
  tblTemp1.Post;

  tblTemp2.Refresh;

  ShowMessage('Table populated.  Both grids show all 3 records.');

  tblTemp1.Filter := 'TextSearch("kw2" in Keywords)';
  tblTemp1.Filtered := True;
  tblTemp2.Filter := 'TextSearch("kw2" in Keywords)';
  tblTemp2.Filtered := True;
  ShowMessage('Filters turned on.  So far, so good!');

  tblTemp1.Filtered := False;
  tblTemp2.Filtered := False;
  ShowMessage('Filters turned off.');

  tblTemp1.Locate('Keywords',VarArrayOf(['kw2']),[]);
  Assert(tblTemp1Keywords.Value = 'kw2');
  tblTemp1.Edit;
  tblTemp1Keywords.Value := '';
  tblTemp1.Post;

  tblTemp2.Refresh;
  ShowMessage('After clearing Keywords field in the second record and refreshing.  Both grids show same results.');


  tblTemp1.Filtered := True;
  tblTemp2.Filtered := True;
  ShowMessage('Filters turned back on.  Why are the results different?');

---

 Comments

---

This could potentially cause problems with text index updates so if you are using full text indexing it is recommended that you update to version 3.18 to correct this issue.

---

 Resolution

---

Fixed Problem on 10/14/2002 in version 3.18 build 1