Re: numeric values in sql

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Carlos Coronel 161.45.250.219 on June 07 2006 18:09:13:

In Reply to: Re: numeric values in sql posted by Dave on May 16 2006 07:34:54:

I got an example. I have a MS Access database with some fields declared as "currency". When using the SQLbuilder scripts, the fields are declared numeric (34). But this does not allow for decimals. Therefore, the decimal precision is lost and the values are rounded up, even though the Insert statememts are correct. I can attribute this to the fact that "currency" is not being translated correctly. Can this bug be fixed?

> SQL Script Builder has been tested, and the use of quotes on numeric values has not been found as a problem.
>
> Can you be more specific on the problems it is causing in your case ? Give more details.
>
> Dave
>
>
> > how come the sql builder still put a quote on the data even if the column is numeric? im having problems on this.
> >
> > thanks.
>

Follow Ups:

Re: numeric values in sql - Dave 06:54:59 June 11 2006 (2)

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> I got an example. I have a MS Access database with some fields declared as "currency". When using the SQLbuilder scripts, the fields are declared numeric (34). But this does not allow for decimals. Therefore, the decimal precision is lost and the values are rounded up, even though the Insert statememts are correct. I can attribute this to the fact that "currency" is not being translated correctly. Can this bug be fixed? > > > > > SQL Script Builder has been tested, and the use of quotes on numeric values has not been found as a problem. > > > > Can you be more specific on the problems it is causing in your case ? Give more details. > > > > Dave > > > > > > > how come the sql builder still put a quote on the data even if the column is numeric? im having problems on this. > > > > > > thanks. > > >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]