adding primary key after the fact?

[Jason Wolfe]

I've posted this question before and not recieved an answer that actually
works. I'm trying not to stop the database to do this so I think that may
pose a problem. I created 3 tables that don't have primary keys... I know,
bad idea...at the time I didn't think I needed them there, and I wouldn't if
it weren't for good old replicator.

Anyway, I need to add primary keys and genID's to these tables so that I can
replicate. I think I need to add a field, create a generator, update the old
values and make sure the generator is updating as we go forward, then I need
to set the field as a primary key.

I run into errors everytime when I make the field a PK! Can someone take a
shot at some code that can accomplish these goals?

Thanks so much.
jason wolfe
--

--

[Bill Todd]

Please do not multipost or cross post your messages. It violates
Borland's guidelines for using their newsgroups and wastes everyone's
time. Please post one message in the most appropriate newsgroup and
please take a moment to read the newsgroup guidelines at
http://info.borland.com/newsgroups/guide.html
--
Bill (TeamB)
TeamB cannot answer questions received via email