Hi,

Got a quick question about replication.  Is there any way to set up
replication where changes to only specific fields are replicated?

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Terry,

No, or at least none that I'm aware of.
You can ONLY select tables to save/load the updates, but not columns.

However, if what you want is to ignore updates for certain columns when
loading updates, then you can define triggers to do that. For example,
suppose you want to update all columns except "c1" and "c2" when loading
updates for the table "t1"; you can get that defining the following trigger:

CREATE TRIGGER "trgT1" BEFORE UPDATE OF "c1","c2"
ON "t1"
WHEN
LOADINGUPDATES()
BEGIN
  SET NEWROW.c1 = OLDROW.c1;
  SET NEWROW.c2 = OLDROW.c2;
END

--
Fernando Dias
[Team Elevate]