Numeric fields as Foreign/required field type in field properties problem

Hello, After 2 years using IB Replication suite, i have a problem. Scenario: Database A and B have the same metadata: Table1 T1 Table2 T2 T2 has a INSERT TRIGGER and a DELETE TRIGGER that updates a numeric(15,2) field (f1) in T1. Databese A replicates to B. Problem: 1) Insert on T1 with f1 = 10.10 2) Insert on T2. INSERT TRIGGER updates T1.f1 = 9.10 3) Replication A to B problem: T1.f1 replicates with 5.5 value (Value changed by TRIGGER) When T2 replicates to B, the INSERT TRIGGER runs in Database B and modifies again the T1.f1 value (i.e. T1.f1 = 8.10) Note: if replication runs between 1) and 2) all is fine, but we have no control over this. Possible solution: Tell the replicator to replicate the T1.f1 Original value (When it was inserted) and Not the actual value. I found that, in the A to B replication schema, setting T1.f1 field properties Field Type to 2.. Foreign/Required field should work but it's not working because its numeric(15,2). We have tested with other field types such as Varchar or integer and worked as expected. So, I think it's a bug that numeric fields can't be foreign/required. Waiting for a solution, Thank you Hernán

Napsal uživatel HarryZ dne Pá, 25.04.2014 - 11:20

Trvalý odkaz

It has been numerous years since a Formula One race has been held in the United States, and the next will be taking place at a brand new racetrack. The Circuit of the Americas, found in Austin, Texas, has just been opened and will have several occasions held until the U.S. Gran Prix runs on Nov. 18. Have you been trying to purchase or sell a used or new 2010 Ford Pickup Ranger Spokane WA? If this seems like you, don’t go any place else before you check out CarDealExpert.com.See more at: http://www.cardealexpert.com/