You are using dublicate field name. So you get an error message.

Example
Create Table Table1
(Field1 Integer not null,
Field2 Varchar(20),
Primary Key(Field1));

When you try to add a field on this table the name of Field1 or Field2, You
will get this error message.
Or may be a problem in interbase field table.
You must change the field name.

Bye...

----- Original Message -----
From: "Antonio Natividad" <locosoft_lnx@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, December 14, 2001 8:53 PM
Subject: [ib-support] Alter table error


> Hello:
>
> I have an error when I'm trying to create a field in a
> table.
>
> First My table had a field named Campo1 and it had an
> Unique Constraint, then I dropped it and the field too
> but when I'm trying to create the field(alter table
> sentence) Campo1 again IB return an error like this:
> ---------------------------------------------------
> Statement failed, SQLCODE = -607
>
> Unsuccesful metadata update
> - STORE RDB$RELATION_FIELDS failed
> - attemp to store duplicate value (visible to active
> transactions) in unique index "RDB$INDEX_15"
> ---------------------------------------------------
>
> What can I do to create my field and my constraint
> again?
>
> Regards
>
> Antonio
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Encuentra el coche de tus sueños en Yahoo! Autos http://autos.yahoo.com.mx
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>