Article Details
| Id: | 10856 |
| Product: | finPOWER Connect |
| Type: | FIX |
| Version: | 1.06.06 |
| Opened: | 10/01/2013 |
| Closed: | 22/01/2013 |
| Released: | 29/01/2013 |
| Job: | J010973 |
 High Importance |
|
Reporting; Account Log List; fails when grouping by Account and ordering by Account Id for SQL Server
The Account Log List report fails when grouping by Account and ordering by Account Id for SQL Server.
The following error message is given:
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
This issue arose since the 'Order By' list contained the AccountId column multiple times. MS Access ignores this but SQL Server fails to execute the query.
All database providers have now been updated to ignore multiple instances of the same field name when generating their SELECT query.