I'm using IBExpert, but I think this is a Firebird issue. If not, just let me know and I'll check with HK.

I foolishly forgot to create and AutoInc generator when I defined a new table. Then I added a record, and deleted it. Now when I try to add the generator I get:
DEFINE GENERATOR failed.
attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_11".

Deleting and recreating the PK field didn't change the message, nor did dropping the table and recreating it. I'm using the same table and field names each time because they adhere to the standards I've used throughout the project. I don't know what else to do other than drop RDB$INDEX_11, but I don't know what else that might do.

I could drop the table, and then recreate it with a different name, but I'd rather not do that, although it would be better than changing the field name of the primary key.

Thanks in advance.