Subject | Alter table error |
---|---|
Author | Antonio Natividad |
Post date | 2001-12-14T18:53:20Z |
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
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