Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Replication Question |
Fri, Jan 30 2009 3:55 PM | Permanent Link |
"Terry Swiers" | 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) --------------------------------------- |
Mon, Feb 2 2009 11:01 AM | Permanent Link |
Fernando Dias Team Elevate | 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] |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |