10.08.2017 20:29, Carlos H. Cantu wrote:
Can someone explain why I can't change a field from numeric (15,4) to numeric (15,6) [error is "New scale specified for column TESTE must be at most 4."], but can change it to numeric (17,6) ?
Because (15, 6) provides less integral precision (9 digits instead of 11) and theoretically some existing values may not fit, making those records unreadable.
e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 6). Dmitry ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel