> Hi all,
>
> I just installed the new Firebird 2.1 server. I have one problem altering a field (it worked in Firebird 2.0.3)
>
> table metadata:
> CREATE TABLE DOCUMENTE (
> ID_DOCUMENTE INTEGER NOT NULL,
> ....
> CURS_VALUTA DECIMAL (18, 4),
> ....
> );
>
> I want to alter curs_valuta to decimal(18,6) so I :
>
> ALTER TABLE DOCUMENTE ALTER CURS_VALUTA TYPE DECIMAL(18,6)
>
>
> I receive the following error :
>
> fmCompile.quCompile:
> This operation is not defined for system tables.
> unsuccessful metadata update.
> New scale specified for column CURS_VALUTA must be at most 4.
>
> Again, in Firebird 2.0.3 this structure change worked without any problems ...

Look here: http://tracker.firebirdsql.org/browse/CORE-1162


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com