Hi Jim

> I can not add a primary key to one of my tables. I am using Interbase
> Workbench and the constraint editor. It gives me an error like:
> Attempt to
> store duplicate value. (Visible to active transactions) in unique
> index
> RDB$PRIMARY19
>
> What???

Assuming that you have existing rows in the table, make sure you don't have
any duplicate values in your columns that you're creating the primary key
on.

If this isn't the case, then what is your table DDL? On what columns are you
creating the PK?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."