Article Details
Id:13567
Product:finPOWER Connect
Type:NEW
Version:3.00.00
Opened:28/01/2016
Closed:02/02/2016
Released:06/07/2016
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.