I need to change the scale of numeric domain from (15,4) to (15,8). I cannot use the ALTER command, since FB doesn't allow such change. BUT I'm 100% sure that all the existing data would perfectly fit in (15,8) so, the question is: In this case, is it safe to make the change direct in the system table?
update RDB$FIELDS set RDB$FIELD_SCALE = -8 where RDB$FIELD_NAME = 'RDB$nnnn'; []s Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br