Subject | unsuccessful metadata update??? |
---|---|
Author | dixonepperson |
Post date | 2003-08-21T20:29:42Z |
when I try to run the statement below, I get the following error.
In my database, there is not a duplication on either the table name
or the field names. What does this mean?
unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
attempt to store duplicate value (visible to active transactions) in
unique index "RDB$INDEX_15"
Creating PAYREGISTER Table
SQL statement: CREATE TABLE PAYREGISTER
(
PY_NUM VARCHAR(20),
PY_TYPE INTEGER,
PY_DATE DATE,
PY_AMT NUMERIC(10,2),
PY_NUM CHAR(6),
PY_VOID CHAR(1) DEFAULT '0',
PY_NOTE VARCHAR(500)
);
Dixon
In my database, there is not a duplication on either the table name
or the field names. What does this mean?
unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
attempt to store duplicate value (visible to active transactions) in
unique index "RDB$INDEX_15"
Creating PAYREGISTER Table
SQL statement: CREATE TABLE PAYREGISTER
(
PY_NUM VARCHAR(20),
PY_TYPE INTEGER,
PY_DATE DATE,
PY_AMT NUMERIC(10,2),
PY_NUM CHAR(6),
PY_VOID CHAR(1) DEFAULT '0',
PY_NOTE VARCHAR(500)
);
Dixon