FIX1.05.06 · Released 25 May 2012
FIXfinPOWER Connect
Released in
1.05.06
25 May 2012
  1. Opened18 May
  2. Closed23 May
  3. Released25 May
Article 10055 Job J009676

Merging queries containing data tables with deleted rows fails

Merging queries containing data tables with deleted rows fails with the following error:

An unhandled exception has occurred.

Deleted row information cannot be accessed through the row.

Many reports use queries that delete rows from their data tables, e.g., to remove Account records that do not fit the specified Overdue range. Attempting to merge one of these queries with another query using the 'Merge Query Results button beneath the grid on the Query Results (or Exported Data) form.