# 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)