I drop all indexes, deleted all rows still the same error?
does someone know why?
Daniel

At 12:54 PM 12/01/2002 -0800, you wrote:

>Hi all,
>I'm wanting to add a primary key to a table? I drop the key field and
>re-created as
>
>ADD sourceid VARCHAR(4) NOT NULL
>
>then I tried to add
>
>ALTER TABLE SOURCE_ID
>ADD PRIMARY KEY (sourceid);
>
>I get this error,
>
>ISC ERROR CODE:335544349
>ISC ERROR MESSAGE:
>attempt to store duplicate value (visible to active transactions) in unique
>index "RDB$PRIMARY5"
>null segment of UNIQUE KEY
>
>what am I doing wrong?
>Please
>Daniel
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/