A very interesting post, I had learned something new.

Greetings.

Walter.

On Mon, Oct 29, 2012 at 2:48 PM, Mark Rotteveel <mark@...>wrote:

> **
>
>
> 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
>
>
>


[Non-text portions of this message have been removed]