Now the link
http://tracker.firebirdsql.org/browse/CORE-1162
works for me.

I do not understand what am I supposed to do.

this is the exact description of my problem :
<<<
SQL> create table tab ( a numeric(4,2) );
SQL> insert into tab values (99.99);
SQL> alter table tab alter a type numeric(4,3);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-New scale specified for column A must be at most 2.
SQL> select * from tab;

A
=======
99.99

>>>

this I do not understand :

<<<
SQL> commit;
SQL> show table tab;
A NUMERIC(4, 2) Nullable
SQL>
[ Show » ]
Philippe Makowski - [28/Jun/07 04:39 AM - edited ] Here what I get under FB-SS-Win32-2.0.1.12855 :
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation And here what I get under FB-SS-Win32-2.1.0.15999 : Statement failed, SQLCODE = -607
unsuccessful metadata update
-New scale specified for column A must be at most 2. details : SQL> create table tab ( a numeric(4,2) );
SQL> insert into tab values (99.99);
SQL> alter table tab alter a type numeric(4,3);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-New scale specified for column A must be at most 2.
SQL> select * from tab; A
=======
99.99 SQL> commit;
SQL> show table tab;
A NUMERIC(4, 2) Nullable
SQL>

[ Permlink | « Hide ]
Philippe Makowski - [02/Jul/07 03:21 AM ]
Closed and test ok and made for 2.1

>>>

Thank you,

Tiberiu


----- Original Message ----
From: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com
Sent: Friday, April 25, 2008 1:31:45 AM
Subject: Re: [firebird-support] firebird 2.1

> 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
__._,_..___
Messages in this topic (2) Reply (via web post) | Start a new topic
Messages
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Recent Activity
* 19
New MembersVisit Your Group
Search Ads
Get new customers.
List your web site
in Yahoo! Search.
Yahoo! Groups
Wellness Spot
A resource for Curves
and weight loss.
Yahoo! Groups
Find balance
between nutrition,
activity & well-being.
.



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