SQL Server datatype 'Money' becomes decimal (0,4)

Data Abstract
1

Hey,

When I create a SQL Server Table with ‘Money’ fields, these fields are translated to decimal (0,4) instead of the datatype Currency in daSchema. Can you look into this?

Thanks.

2

what DA driver you were used?
what platform (Delphi of .NET) you are using?

3

DA for .NET version 9.1.99.1273.

4

Hello

Could you provide more details please? Like DB driver being used, table definition and exact steps to reproduce the issue?
I’ve just tried to add to schema a simple table with MONEY and SMALLNONEY fierlds and they were added as fields with the Currency data type.

Regards

5

Hello,

It happens when we add a new field to an existing DataTable in daSchema. DA Schema Modeler askes if we want to update the fields, and then our existing MONEY fields become DECIMAL(0,4) fields.
You have for example an existing DataTable ‘Sales’ with 1 AUTOINC and 3 MONEY fields (CURRENCY in daSchema). We close daSchema. Then we reopen it and add another field in the sql statement (it doesn’t matter which type). Then we get the question if we want to update our Fields. After that our 3 existing MONEY fields become DECIMAL(0,4) fields.

DB = SQL Server 2016

Regards

6

Hello

It still doesn’t reproduce on the latest Beta, so it might be something specific to the table or connection string settings.

Please send your Schema file (delete there everything except the money-fields table), connection string (replace there server name, user Id and password with ###) and table’s DDL to support@

Regards