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



Thank you in advance,

Tiberiu








____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ