Icon View Incident Report

Serious Serious
Reported By: Bernd Kuhlmann
Reported On: 11/1/2005
For: Version 4.21 Build 10
# 2122 Table Cursors Not Detecting Changes During Manual Refresh With Active Filters and Ranges

When have a filtered table (using the filter property) with a Range set on an indexed field. When we refresh this table, it sometimes shows not the records which where added in the meantime in another session.

The following steps are required:

- start dbsys and open then table interneMails
- go to the last record
- check "Copy On Append"
- start the program refreshtest.exe
- click on "Button1"
- in dbsys append and post a new record
- click on "Button1"
-> the new record is not shown
- in dbsys append and post a second record
- click on "Button1"
now both records are shown

procedure TForm1.Button1Click(Sender: TObject);
begin
  tbEingang.Refresh;
  tbEingang.SetRange([16],[16]);
  tbEingang.Last;

  tbAusgang.Refresh;
  tbAusgang.SetRange([16],[16]);
  tbAusgang.Last;
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
  tbAusgang.IndexFieldNames:='VonBenutzer;Datum';
  tbAusgang.Filter:='geloescht=false';
  tbAusgang.Filtered:=True;
  tbAusgang.open;
  tbEingang.IndexFieldNames:='AnBenutzer;Datum';
  tbEingang.Filter:='geloescht=false';
  tbEingang.Filtered:=True;
  tbEingang.open;
end;



Comments Comments
The problem only occurs when you have more than one table component open on the same physical table.


Resolution Resolution
Fixed Problem on 11/8/2005 in version 4.22 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image