Article View: borland.public.interbase.replication
Article #24Re: Another Changing primary key and replicate this value question
From: Steve Ball
Date: Sun, 16 May 2004 11:31
Date: Sun, 16 May 2004 11:31
40 lines
2197 bytes
2197 bytes
Miguel, Try this, this will make it replicate, but you might find it better practice to add another field and do the work on that. UPDATE MYTABLE SET UID = UID; This will trick the triggers into replicating that record without changing the primary key. Steve "Miguel" <art21o@hotmail.com> wrote in message news:4057307f$1@newsgroups.borland.com... > > Ok, I understand. Are there another for to do a replicate, like a mirror or something? Another software...? Any tip. > > Thx anyway... > > Arturo > > > > "Craig Stuntz [TeamB]" <cstuntz@nospam.please [a.k.a. vertexsoftware.com]> wrote: > >Miguel wrote: > > > >> Are there another form to do this?? I have an application to do > >> this (change the primary key every time a document is modify) Can the > >> replicator be work or never mind (may be in a 1.5 version). > > > > You should never change PK values. Ever. Especially not if you're > >doing replication. > > > > -Craig > > > >-- > >Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH > > Delphi/InterBase Weblog : http://delphi.weblogs.com > >InterBase Performance Monitor -- Analyze and control your IB7 > > server: http://delphi.weblogs.com/IBPerformanceMonitor >
Technical Details
Message-ID:
<40a75105@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsrout1.ntli.net!news-in.ntli.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4056582b$1@newsgroups.borland.com> <40570bbe$1@newsgroups.borland.com> <4057307f$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,401314397655db1c X-Google-Attributes: gidf89d7,public From: "Steve Ball" <SteveBall@noSpam.uku.co.uk> Newsgroups: borland.public.interbase.replication References: <4056582b$1@newsgroups.borland.com> <40570bbe$1@newsgroups.borland.com> <4057307f$1@newsgroups.borland.com> Subject: Re: Another Changing primary key and replicate this value question Date: Sun, 16 May 2004 12:31:17 +0100 Lines: 42 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 NNTP-Posting-Host: 81.5.146.45 Message-ID: <40a75105@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1084707077 81.5.146.45 (16 May 2004 04:31:17 -0700) Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsrout1.ntli.net!news-in.ntli.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail