🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #24

Re: Another Changing primary key and replicate this value question

#24
From: Steve Ball
Date: Sun, 16 May 2004 11:31
40 lines
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-mail
References: <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