adding primary key after the fact?

Article View: borland.public.interbase.replication

Article #66

Back to borland.public.interbase.replication Previous Next

#66

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


--

Technical Details

Message-ID: <41a215ce$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsgate.cistron.nl!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f89d7,c4d03926c0b5939,start
X-Google-Attributes: gidf89d7,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Jason Wolfe" <jason@infuselabs.com>
Newsgroups: borland.public.interbase.replication
Subject: adding primary key after the fact?
Date: Mon, 22 Nov 2004 09:37:43 -0700
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 67.162.157.61
Message-ID: <41a215ce$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1101141454 67.162.157.61 (22 Nov 2004 08:37:34 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsgate.cistron.nl!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail