Decimal Precision in SP

[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. Clay]

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