Decimal Precision in SP

  • Thread starter Thread starter Bruce Loving
  • Start date Start date
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
 
Set prm = cmd.CreateParameter("@Quantity", adDecimal,
adParamInput, , Nz(Me!txtOrderQnty, 0))
prm.Precision = 9
prm.NumericScale = 3
cmd.Parameters.Append prm
 
Back
Top