Re: how to use DB_NUMERIC in OLEDB ?

"davidshen" <davidshen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2D0B1716-0EBC-45BE-A079-39D9D5909427@xxxxxxxxxxxxxxxx
>i want to use a DB_NUMERIC variable to update my MSSQL2K, the number i want
> to send is 55.5, and i set DB_NUMERIC using the following code:
> DB_NUMERIC num;
> num.precision=5;
> num.scale=2;
> num.sign=1;
> long tmp = long (55.5*100) // which is 5550, 15ae in hex
> memset(num.val,0,16); // the length of num.val is 16
> memcpy(num.val, &tmp, sizeof(long));// bit copy
>
> but on the sql server side, the number it stored is 55
> what's the problem with my code?

Why would you expect a long to hold a decimal? Try using a float, double or
long double.

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.

Relevant Pages
Loading