adding primary key after the fact?

Thread View: borland.public.interbase.replication

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Jason Wolfe Mon, 22 Nov 2004 16:37

#66

Author: Jason Wolfe
Date: Mon, 22 Nov 2004 16:37

20 lines
1660 bytes

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


--

Re: adding primary key after the fact?

#67

Author: Bill Todd
Date: Mon, 22 Nov 2004 20:26

8 lines
1312 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads