Hi all,
I'm trying to write a fixed-length number to a SQL Server Non Spatial database, and most work fine, but this one doesn't -
Microsoft SQL Server Non-Spatial Writer: Unable to format data '4411398' for column 'ciFloorArea' of type 'numeric(8,2)'
The other numbers look like so, and must be the exact 8 and 2 parameters -
1305
2568
4411398
8248072
I just wondered if there was anything I was missing with the one that's throwing the error up?
Thanks
@joe.fme I think that for numeric(p,s) the p is the total number of digits and s (scale) the number of decimals. So for numeric(8,2) the largest number would be 999999.99. SQL Server docs has more details
@joe.fme I think that for numeric(p,s) the p is the total number of digits and s (scale) the number of decimals. So for numeric(8,2) the largest number would be 999999.99. SQL Server docs has more details
Hi Mark,
Ok so looking at the number lengths, despite the source database having those "p" and "s" numbers, it's not suited for now as the number is too large.
That clears up a lot - thanks :)