
Conditional replication
Vložil admin, St, 2006-12-06 13:08
Q: I try writing in replication manager the condition but it not work, how do I write condition WHERE NEW.XYZ=-1? Actually I must solve the problem changing the directly the trigger in (VAR$COND>0 AND NEW.XYZ = -1).
A: You should set VAR$COND to 0 if XYZ<>-1
Example:
IF ({#CXN#}.XYZ<>-1) THEN VAR$COND = 0; /* do not replicate */
» Přihlašte se, abyste mohl psát komentáře | previous forum topic | next forum topic | 3725 x přečteno