MS SQL currency type shown as float in schema builder

Data Abstract
1

hi, using SDAC with DA, the MS SQL currency type is still being treated as float…
is there a way to change that?

2

Hi,

have you tried to specify datCurrency type for this field?

3

you mean change this manually?
yes off course, otherwise it’s treated as a float instead of a currency in delphi…

4

point is that the schema builder should make it datcurrency instead of datfloat no?

5

what sql type do you have for this table? auto sql or custom sql? in case of custom sql, datatypes were detected by SDAC

6

hmmm don’t see why it should be different in either case but we use custom sql yes…

7

in case of autosql we read data types directly from table metadata
in case of custom sql, we use data types that returns correspondent DAC (in your case SDAC) because you can have complex SQL like

select 
    1.0+2.3 as fld1, 
    (select a from tableB ...) as fld2
...
8

i understand, so i have to take it up with devart then?

9

according to https://www.devart.com/sdac/docs/data_type_mapping.htm , they already map decimal(10,4) to ftBCD

10

so?
does this mean you interpret ftbcd as datfloat then?
can we change the mapping so the schema builder sees it as currency?
this is very annoying, cause every time you add a field to the query, all currency fields are float again, which results in unwanted behaviour in our app like to many digits when calculating when currency is expected

11

try to create table with autosql. how to fields will be declared - as float or currency?

12

autosql does create the fields as currency…

13

so problem with SDAC. probably this mapping isn’t set by default …

14

correct me if i’m wrong, but i guess autosql also uses the sdac connection or not?

15

bottom line, i need a solution for this cause it results in errors for our clients and i do not always keep in mind to check float vs currency…

16

yes, SDAC connection is used.

for autosql we call MSSQL_DoGetTableFields method (uDAADOInterfaces.pas) that read table metadata

17

try to add to aux parameters of connection: EnableBCD=True. it may help

https://www.devart.com/sdac/docs/devart.sdac.tmsdatasetoptions.enablebcd.htm

18

call me stupid but how do i do that? :slight_smile:

19

something like

untitled
untitled.png496×768 16.1 KB

20

hmmm tried that but didn’t work, will retry