> 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)
> );

You have declared the field PY_NUM twice.



Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase/Firebird
http://www.iblogmanager.com