Icon View Incident Report

Serious Serious
Reported By: Michael Binette
Reported On: 7/1/2002
For: Version 3.10 Build 1
# 1148 Re-Connecting to a Disconnected Session with Active OnFilterRecord Filters Causes Problems on Server

On a form I put:

- 1 TDBISAMDatabase component - connected to a remote session called TestSession.

- 1 TDBISAMSession component - with SessionType stRemote and SessionName TestSession.

- 1 TDBISAMTable component - with Filtered = true, SessionName = TestSession, and an OnFilter event that will filter out 1 out of 10 records using a simple string comparison on one column.

- 1 TDataSource connected to the TDBISAMTable.

- 1 TDBGrid connecte to the TDataSource.

- 1 button that opens the table. All components are have Active set to False initialy.

- 1 button that calls TDBISAMTable.Refresh.

I run the application, click on the Open button and the grid properly fills in with the filtered records. I have set my server to timeout a session after 60 seconds for testing. I wait the sixty seconds and then click the Refresh button.

I get the exception since I am running through Delphi, basically saying the session is dead. It connects the session again (using the Server Administration Utility on the Server to view the current connections) but then the data does not exist. The TDBGrid is now empty with no data. Clicking Refresh a bunch of times doesn't update it and the table truly thinks it is empty (EOF and BOF are true). I then have to Close and then Open the table for the data to return. If I set Filtered to false on the TDBISAMTable, this does not occur.


Resolution Resolution
Fixed Problem on 7/6/2002 in version 3.11 build 1
Image