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.