Re: numeric values in sql

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

Posted by Dave on June 11 2006 06:54:59:

In Reply to: Re: numeric values in sql posted by Carlos Coronel on June 07 2006 18:09:13:

With version 1.42, currency values are now declared numeric (15,4). This should solve the problem.

If you want to use the 'money' or 'smallmoney' of MS SQL, deactivate quotes with numeric fields and reedit the script by replacing the 'numeric' declaration.

Thanks for feedback,
Dave

> 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:

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> With version 1.42, currency values are now declared numeric (15,4). This should solve the problem. > > If you want to use the 'money' or 'smallmoney' of MS SQL, deactivate quotes with numeric fields and reedit the script by replacing the 'numeric' declaration. > > Thanks for feedback, > Dave > > > 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 ]