Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

wrong scale value!! for sp

Status
Not open for further replies.

pollux0

IS-IT--Management
Mar 20, 2002
262
US
I m getting a wrong scale value error message when executing a sql stored proc from as asp page I know there should be a fourth parameter like:
("@totalTotal", addecimal, adParamOutput, 30,2)
but I get errors. thanks in advance!

**********ASP*********************
set objParameter9 = objCommand.createParameter ("@totalTotal", addecimal, adParamOutput)

objCommand.parameters.append objParameter9
*******************************

in the sp, the parameter is

**********SQL*********************
CREATE PROCEDURE createInvoice
@totalTotal decimal(30,2) output
AS....
*******************************
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top