0x80004005: The precision is invalid.

[DJP]

Hi,
I am Tring to send a decimal to a SQL stored Procedure and get a The
precision is invalid.

The Fields are set for 4 precision 2 scale decimal

@HOURHoliday [decimal](4,2),
@HOURSOT [decimal](4,2),
@HOURSREG [decimal](4,2),
@HOURSVAC [decimal](4,2),

The ado code area is

P.Append CN.CreateParameter("@HOURHoliday",adDecimal,1,4)
P.Append CN.CreateParameter("@HOURSOT",adDecimal,1,4)
P.Append CN.CreateParameter("@HOURSREG",adDecimal,1,4)
P.Append CN.CreateParameter("@HOURSVAC",adDecimal,1,4)

this code also result in the same error
P.Append CN.CreateParameter("@HOURHoliday",adDecimal,1)
P.Append CN.CreateParameter("@HOURSOT",adDecimal,1)
P.Append CN.CreateParameter("@HOURSREG",adDecimal,1)
P.Append CN.CreateParameter("@HOURSVAC",adDecimal,1)

this is where the paramater are set
CN("@HOURHoliday") = HolidayHours
CN("@HOURSOT") = OverTimeHours
CN("@HOURSREG") = RegularHours
CN("@HOURSVAC") = VacationHours

I am sure there is a problem between the stored proc and the ado pramater.
basic value I would send to all is like 10.75

D

[Bob Barrows]

You cannot set the precision and scale properties in the CreateParameter
method. Those Parameter properties need to be set after the Parameter is
completed. You may want to try my Stored Procedure Code generator. It is
available here:
[url]http://www.thrasherwebdesign.com/index.asp?pi=links&hp=links.asp[/url]

HTH,
Bob Barrows

DJP wrote:

> Hi,
> I am Tring to send a decimal to a SQL stored Procedure and get a
> The precision is invalid.
>
> The Fields are set for 4 precision 2 scale decimal
>
> @HOURHoliday [decimal](4,2),
> @HOURSOT [decimal](4,2),
> @HOURSREG [decimal](4,2),
> @HOURSVAC [decimal](4,2),
>
> The ado code area is
>
> P.Append CN.CreateParameter("@HOURHoliday",adDecimal,1,4)
> P.Append CN.CreateParameter("@HOURSOT",adDecimal,1,4)
> P.Append CN.CreateParameter("@HOURSREG",adDecimal,1,4)
> P.Append CN.CreateParameter("@HOURSVAC",adDecimal,1,4)
>
> this code also result in the same error
> P.Append CN.CreateParameter("@HOURHoliday",adDecimal,1)
> P.Append CN.CreateParameter("@HOURSOT",adDecimal,1)
> P.Append CN.CreateParameter("@HOURSREG",adDecimal,1)
> P.Append CN.CreateParameter("@HOURSVAC",adDecimal,1)
>
> this is where the paramater are set
> CN("@HOURHoliday") = HolidayHours
> CN("@HOURSOT") = OverTimeHours
> CN("@HOURSREG") = RegularHours
> CN("@HOURSVAC") = VacationHours
>
> I am sure there is a problem between the stored proc and the ado
> pramater. basic value I would send to all is like 10.75
>
> D