Re: Trouble passing a numeric data type

Its a general purpose error saying there were multiple errors and not work
was done. I did try using adDecimal but maybe it's the precision and scale
that is the problem.

thanks.

"Val Mazur (MVP)" <group51a@xxxxxxxxxxx> wrote in message
news:e19KlETnFHA.2916@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Try to use adDecimal. I believe you also need to specify precision and
scale
> for your parameter. What kind of error did you get?
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "Ellie" <nospam@xxxxxxxxxx> wrote in message
> news:%23mBS8cQnFHA.2156@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> >
> > My table has a numeric data type but when I try to use adNumeric to pass
a
> > numeric data type to my stored procedure, I get an error. It only seems
to
> > work if I declare the parameter as an int data type and add the
parameter
> > to
> > the command as adInteger. Any help would be appreciated.
> >
> >
>
>


.

Relevant Pages

  • Re: NUMBER(p) vs. INTEGER data type and CHAR(x) vs. VARCHAR2(x) in Oracle 10g and 9i - advantage
    ... scale) gives you an integer, constrained by a max of p digits. ... since 38 is the max precision? ... CHAR data type? ... There are numbers in the Oracle DB, the definitions of the others are types ...
    (comp.databases.oracle.server)
  • Re: how to map datatypes...
    ... represents a signed, numeric data type with a precision of 11 and no scale, ... meaning that there can be no digits to the right side of the decimal. ... a precision of 11 requires 9 bytes: ... Use the int data type to store numbers in the range from -2,147,483,648 ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Trouble passing a numeric data type
    ... I believe you also need to specify precision and scale ... Val Mazur ... > numeric data type to my stored procedure, ...
    (microsoft.public.vb.database.ado)
  • Re: syntax to add decimal column to access table using SQL?
    ... set the data type in SQL to numeric and the precision value to 10 and then ... the scale value to 3 ...
    (microsoft.public.access.gettingstarted)
  • Re: new here, my lang project... PT2
    ... The scale is limited by the resolution of ... I see this as a precision vs. accuracy issue. ... > physics core ... > just I am not sure how necessary the partitioning is at present. ...
    (comp.object)
Quantcast