Icon View Incident Report

Serious Serious
Reported By: Mike O'Grady
Reported On: 7/8/2004
For: Version 4.08 Build 1
# 1790 Multiple Executions of a Remote Query with an OnFilterRecord Event Handler Causes #9482 Error

I need to reproduce a report using DBISAM that is currently working fine with BDE Paradox tables and queries. The new implementation will use a remote server.

Master Table - Customers (no filters)
Detail Query - Transactions (5 filter conditions in OnFilterRecord event)
Reporting Tool - ReportBuilder

ReportBuilder cycles through the Customers table and prints the header data. The filtered detail data is automatically selected for the detail band of the report.

When I converted to DBISAM, the detail data for some customers was displaying incorrectly. (This could be a ReportBuilder issue - notwithstanding the fact that it worked with BDE tables) Eventually, I found that forcing a refresh of the query for each change in the master data fixed the problem.

However, the performance was terrible because I used Open rather than Prepare and ExecSQL to start the query. Preparing the query and using ExecSQL fixed the performance issue but, after about 6 customers, I get "Error 9482: Too many filters defined for table 32681". (32681 means nothing to me so I assume that it is some sort of internal handle)

Comments Comments
This problem was also reported by Kevin Stanton of ACS Technologies on the May 28th, 2004, but unfortunately we were unable to reproduce the problem and he indicated that there were no filters in use.

Resolution Resolution
Fixed Problem on 7/18/2004 in version 4.09 build 1