Prepared Statement?

[Phill]

I have a Access frontend/SQL Server 2K backend. I am
calling a stored procedure to insert my records. My
problem is I don't know how to code it for decimal
parameters. The database field is defined as a float,
the stored procedure is expecting a decimal (I've also
tried numeric), and the VBA code creates the parameter as
decimal (also tried numeric). I get a precision error.
How do I code this? Here is my VBA code for the
parameter creation.


cmd2.Parameters.Append .CreateParameter( _
"@TOTAL_QUANTITY", adNumeric,
adParamInput, , rstDetails("TOTAL_QUANTITY"))

 

[solex]

Phil,

You may want to explicitly define a variable for the value argument and use
the adDouble constant for the parameter, for instance

Dim qty As Double

qty = rstDetails("TOTAL_QUANTITY").Value

cmd2.Parameters.Append .CreateParameter( _
"@TOTAL_QUANTITY", adDouble, _
adParamInput, , qty)

Regards,
Dan