On 29-10-2012 17:48, Carlos H. Cantu wrote:

> MR> No, a direct system table update like that would rescale all your existing
> MR> numbers. Eg from (15,4) to (15,8) a value 54321.1234 would become
> MR> 5.43211234
>
> Not really. You can test by yourself... seems that stored values are
> associated with a record in RDB$FORMATS that describes the original
> format when they were stored, and when FB retrieves the value, it
> respects the original format (thanks Ivan for the note).
>
> My tests showed no problem with my proposed approach. I posted here
> just to make sure that it would not have any side effects that I didnt
> see yet. If someone knows any, please post here.

Ok, good to know that. I didn't know that the formats were also
maintained when not using DDL.

Mark
--
Mark Rotteveel