Re: adNumeric cutoff

From: Ashok Gupta <ashokghr_at_hotmail.com>
Date: Mon, 24 Mar 2003 19:14:50 +0530
Message-ID: <eBfF6ug8CHA.1776@TK2MSFTNGP10.phx.gbl>

I hope u used the precision and other property as shown below?

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_SIZE", adNumeric, adParamInput, 0, Weight)

   CMD.Parameters("C_LINES_SIZE").Precision = 4
   CMD.Parameters("C_LINES_SIZE").NumericScale = 2
   CMD.Parameters("C_LINES_SIZE").Size = 5
   CMD.Parameters.Append CMD.CreateParameter("C_LINES_WEIGHT", adNumeric,

adParamInput, 0, Weight)

   CMD.Parameters("C_LINES_WEIGHT").Precision = 6
   CMD.Parameters("C_LINES_WEIGHT").NumericScale = 3
   CMD.Parameters("C_LINES_WEIGHT").Size = 5

right? if not try this, this should work. HTH
Ashok Gupta

"Zev Itzkowitz" <zev.itzkowitz_at_sndiamonds.com> wrote in message news:b07ccfa5.0303230720.5aefe1d6_at_posting.google.com...
> Hi!
>
> The following is a snippet of code that I am having problems w/:
>
> set CMD = server.CreateObject("ADODB.Command")
> CMD.ActiveConnection = Con
> CMD.CommandType = adCmdStoredProc
> CMD.CommandText = "INSERT_WEB_ORDER_LINES"
>
> CMD.Parameters.Append CMD.CreateParameter("C_LINES_ORDER_NUMBER",
> adNumeric, adParamInput, 0, OrderNum)
> CMD.Parameters.Append CMD.CreateParameter("C_LINES_ORDER" ,
> adNumeric, adParamInput, 0, LineNum)
> CMD.Parameters.Append CMD.CreateParameter("C_LINES_ITEM" ,
> adVarChar, adParamInput, 10, item)
> CMD.Parameters.Append CMD.CreateParameter("C_LINES_SIZE" ,
> adNumeric, adParamInput, 0, weight)
> CMD.Parameters.Append CMD.CreateParameter("C_LINES_CERT_NUM" ,
> adVarChar, adParamInput, 12, stone_code)
> CMD.Parameters.Append CMD.CreateParameter("C_LINES_CERT_TYPE" ,
> adVarChar, adParamInput, 2, BRString)
> CMD.Parameters.Append CMD.CreateParameter("C_CERT_TYPE" ,
> adVarChar, adParamInput, 10, BRString)
> CMD.Parameters.Append CMD.CreateParameter("C_LINES_WEIGHT" ,
> adNumeric, adParamInput, 0, weight)
> CMD.Parameters.Append CMD.CreateParameter("C_DESCRIPTION" ,
> adVarChar, adParamInput, 30, description)
> CMD.Parameters.Append CMD.CreateParameter("C_DEDICATE" ,
> adVarChar, adParamInput, 20, dedicate)
>
>
> What's happening is that the string fields in btwn C_LINES_SIZE and
> C_LINES_WEIGHT are being passed as NULL. In the database,
> C_LINES_SIZE is defined as NUMBER(4,2) and C_LINES_WEIGHT is defined
> as NUMBER(6,3), and decimal numbers are being passed in. I tried
> setting the precision and numeric fields on those numerics, but the
> same thing keeps happening. Anyone have any idea why?
>
> Our work around was to call the stored procedure directly, but
> theoretically, this way should work under all circumstances. Thanx.
>
> Zev
Received on Mon Mar 24 2003 - 07:44:50 CST