Changing primary key and replicate this value

Article View: borland.public.interbase.replication

Article #2

Back to borland.public.interbase.replication Previous Next

From: David Domingo
Date: Thu, 19 Feb 2004 15:52

19 lines
1461 bytes

Hi all,

  How can I replicate any changes of primary key? It is possible?

  When I change some field of my primary key this record try to replicate to
target database but this params are the values of newkey instead of oldkey.
  Maybe... well I'm sure that the best solution could be: when reptype=U
(for updates) always fill the params for the updatesql with oldkey values
and always change primary key with newkey values.

  But with IBRepl version 1.1 is possible?

Regards

-- 
David Domingo
Dpto. Inform�tica
Star Seguridad Integral, S.A.
Tel.: 96 335 15 01

Technical Details

Message-ID: <4034dce9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!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-Language: ENGLISH,ASCII
X-Google-Thread: f89d7,2f886c55ebe3c509,start
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2004-02-19 08:10:46 PST
From: "David Domingo" <david.domingo@starseguridad.com>
Newsgroups: borland.public.interbase.replication
Subject: Changing primary key and replicate this value
Date: Thu, 19 Feb 2004 16:52:16 +0100
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 80.58.245.158
Message-ID: <4034dce9$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1077206249 80.58.245.158 (19 Feb 2004 07:57:29 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail