Article Details
Id:9667
Product:finPOWER Connect
Type:FIX
Version:1.04.05
Opened:10/02/2012
Closed:29/02/2012
Released:02/03/2012
Job: J008962

Workflows Add-On; Account Processes; Selecting a single workflow results in a 'Failed to open DataTable' error.

Running Account Processes for Workflows.

If a range of Workflows is entered it errors with "Failed to open DataTable. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."

The workflow range was being added incorrectly to the SQL query.