Persist Decimal Data to SQL Server through Stored Procedure in VB

[fiona_conard]

Hi all,


I would like to persist a decimal data to sql server which is defined as decimal(4,2).

In VB, i prepare parameter like this:

Set prm = cmd.CreateParameter("Num", adDecimal, adParamInput, , 1.24)

and then execute the stored procedure.

The value is rounded up to 1 in the database. Why? What should i do?

Thanks!