Subject | FB 2.1 and ALTER DOMAIN |
---|---|
Author | Luis Madaleno | magnisoftR |
Post date | 2008-05-06T14:00:16Z |
Hi,
I have this domain:
CREATE DOMAIN PERCENTAGENS AS NUMERIC(10,2) DEFAULT 0;
Till FB 2.0.3 I could change the domain type with this command:
ALTER DOMAIN PERCENTAGENS TYPE NUMERIC(10,4);
But in FB 2.1 this fails with the message:
This operation is not defined for system tables.
unsuccessful metadata update.
New scale specified for column PERCENTAGENS must be at most 2.
Is there a way to achieve this in FB 2.1?
Thanks,
Luis Madaleno
[Non-text portions of this message have been removed]
I have this domain:
CREATE DOMAIN PERCENTAGENS AS NUMERIC(10,2) DEFAULT 0;
Till FB 2.0.3 I could change the domain type with this command:
ALTER DOMAIN PERCENTAGENS TYPE NUMERIC(10,4);
But in FB 2.1 this fails with the message:
This operation is not defined for system tables.
unsuccessful metadata update.
New scale specified for column PERCENTAGENS must be at most 2.
Is there a way to achieve this in FB 2.1?
Thanks,
Luis Madaleno
[Non-text portions of this message have been removed]