NEW3.00.00 · Released 6 July 2016
NEWfinPOWER Connect
Released in
3.00.00
6 July 2016
  1. Opened28 Jan
  2. Closed2 Feb
  3. Released6 Jul
Article 13567 Job J016830

Database Schema information; updated SQL Server Get Database Schema functionality

Database Schema information for SQL Server has been enhanced as follows:

  1. Now supports Currency and Numeric data types as Decimal values.
    • Equivalent Access database column type is Currency.
    • This may cause issues if very large values are stored in the database.
  2. If the Column Type is not one of the basic types that finPOWER Connect supports the Schema is flagged as "Incomplete" and the column's Data Type is set to "Other".

Database Copy

Will immediately fail if the database is flagged as "Incomplete" - this is existing behaviour, but with the change above causes this to change.

Compare Databases

No longer fails if Schema is "Incomplete".

Document Database

Now does not fail if Schema is "Incomplete".

Instead it shows the incomplete message at the top of the Report.