Decimal Precision in SP

B

Bruce Loving

have written an SP with a parameter of
DECIMAL(5,2)

now trying to Call SP with Access 2000

adocmd.createparameter("RATE",addecimal,adinputparameter,???,35.24)
adocmd.execute

getting Invalid Precision error message when
executing
 
J

J. Clay

Set prm = cmd.CreateParameter("@Quantity", adDecimal,
adParamInput, , Nz(Me!txtOrderQnty, 0))
prm.Precision = 9
prm.NumericScale = 3
cmd.Parameters.Append prm
 
Top