Subject | Re: Numeric(15,2) problem in Firebird v 2.1.2 |
---|---|
Author | Abhishek Sharma |
Post date | 2009-05-14T06:47:30Z |
Thankyou for your reply. we apreciate it.
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 02:20 PM 14/05/2009, you wrote:
> >Hi group.
> >
> >I m facing a problem in the v2.1.2, i m trying to post a value as a string in a column which has data type as Numeric(15,2)
> >For eg: - Update table set col='10,000.00' where condition.
> >the query works fine in v 2.0 but in 2.1.2 i m getting a "conversion error from string" with error code -413
> >
> >Please help why i m getting so
>
> V.2.1 is a lot *meaner* than v.2.0 about enforcing standards when parsing inputs for conversion. Under standards, only digits and the point character are valid in numbers. Where V.2.0 and 1.5 would issue warnings (ignored by developers) V.2.1 comes right out and tells it like it is.
>
> Remove the comma.
>
> ./hb
>