Another Changing primary key and replicate this value question

Thread View: borland.public.interbase.replication

5 messages

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

5 total messages Started by Miguel Tue, 16 Mar 2004 01:28

#16

Author: Miguel
Date: Tue, 16 Mar 2004 01:28

9 lines
1119 bytes

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

Please I need to know if it can work for buy it?

Thx, Anyway

Arturo

Re: Another Changing primary key and replicate this value question

#17

Author: Craig Stuntz TeamB
Date: Tue, 16 Mar 2004 14:14

16 lines
1492 bytes

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

Re: Another Changing primary key and replicate this value question

#18

Author: Miguel
Date: Tue, 16 Mar 2004 16:51

25 lines
1742 bytes

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

Re: Another Changing primary key and replicate this value question

#19

Author: Craig Stuntz TeamB
Date: Tue, 16 Mar 2004 17:35

17 lines
1573 bytes

Miguel wrote:

> Ok, I understand.  Are there another for to do a replicate, like a
> mirror or something?  Another software...? Any tip.

	You should not change a primary key value with any software.  The
entire purpose of a primary key is to be an unchanging way to identify
a record. If your "PK" values are changing then you don't have a real
primary key.

	-Craig

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase 7 supports long-running transactions; read more here:
  http://delphi.weblogs.com/stories/storyReader$379

Re: Another Changing primary key and replicate this value question

#24

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

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