Abhushek Sharma wrote:
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
Helen Borrie answers:
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.