Devart Forums

I have a connection as below

UniConnection.DataTypeMap.AddDBTypeRule(msDecimal, 0, 0, ftBCD, 12, True);

The fields are created as BCDField working perfectly.
However, when making an "insert" the command is generated with float parameters and not as money.

exec sp_executesql N'INSERT INTO UniTeste
(n2, n4, n6, f)
VALUES
(@P1, @P2, @P3, @P4)',N'@P1 float,@P2 float,@P3 float,@P4 float',0.349999999999,0.349999999999,0.349999999999,0.349999999999

What configuration can I do to modify the parameters generated in the INSERT \ UPDATE commands com money datatype
?

Exemple:
exec sp_executesql N'INSERT INTO UniTeste
(n2, n4, n6, f)
VALUES
(@P1, @P2, @P3, @P4)',N'@P1 money,@P2 money,@P3 money,@P4 money',$0.3500,$0.3500,$0.3500,$0.3500

regards,
Fontenele

Unfortunately, we couldn't reproduce the issue. To investigate this behavior of UniDAC, please compose a full sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html