If I'm not wrong the scenario is this:

To change IBExpert use a temporary field. Copying values from actual field
in temporary, drop actual, rename temp field to actual field. This way
avoid restriction to change from langer to smaller field! For text field, I
think , will truncate the field values.



Regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Erick Sasse
Sent: Thursday, March 08, 2007 5:14 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Changing numeric domain precision and scale

> Perhaps Erick is using a tool which manipulates system tables directly?

;-)

I've used IBExpert, but I don't think it's manipulating system tables
without telling me. :)
I did not enable the option to allow it.

I think the command it sent to the database was a simple:

ALTER DOMAIN MY_DOMAIN TYPE NUMERIC(15,2);

And it worked.

--
Erick Sasse





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