Chris Byrom
Nov 9th, 2000, 03:14 PM
Hello everybody.
I am having a problem passing a variable to a stored procedure. I am calling an MTS object to run the procedure. Everything is working fine, except one SQL field. The field is of type Decimal, length is 9, precision is 10, and scale is 5. If I pass the parameter, which has a value of 1.5, to the ADO command object as type adInteger, it works but is rounded. The variable is a short. I can change it if need be. I tried passing it to the proc as type adDecimal, but I get an error. Does anyone know how I should set up this parameter?
Thanks.
I am having a problem passing a variable to a stored procedure. I am calling an MTS object to run the procedure. Everything is working fine, except one SQL field. The field is of type Decimal, length is 9, precision is 10, and scale is 5. If I pass the parameter, which has a value of 1.5, to the ADO command object as type adInteger, it works but is rounded. The variable is a short. I can change it if need be. I tried passing it to the proc as type adDecimal, but I get an error. Does anyone know how I should set up this parameter?
Thanks.