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