Hi
I've been trying to find out about the following with the new V8
replication.
I want to publish a table but when subscribing I only want to update certain
fields in the table plus based on the data coming in I want to update some
totals in another table (while a trigger is possible - it must only apply to
replicated data). Is this possible? With another well known database, this
is possible by defining the SQL.
You will be able to do it with the upcoming 8.1 release. Currently it's
only possible to set a horizontal filter. Another approach: Create a
table which contains only the needed data, fill it through a trigger on
the main table and also set a trigger on that table to move the data
back to the main table.
--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de
*********** European Advantage Conference (EAC) 2006 ****************
Do you want to develop faster, deliver better solutions and drive your
business forward?
Plan to attend now THE Advantage event of the Year!
+++ UK - London, 8.-9. May
+++ GERMANY - Frankfurt, 11.-12. May
+++ ITALY - Milano, 15. May
EARLY BIRD RATES open until 31. March: 199 ?/? instead of 299 ?/?
(Milano 149/199 ?)
Click for Details: http://www.AdvantageDatabase.com/EAC2006
*********** European Advantage Conference (EAC) 2006 ****************