Will a publication upload trigger-generated data to Mobilink?

SQL Anywhere 11.0.1.2231 Oracle 10g

We have a Mobilink setup we are testing. We have an after update trigger on TableA that writes data to TableB.

We have TableB (and all columns except last_updated) included in a Publication.

If I insert directly to TableB, Mobilink uploads the data.

If I insert to TableA, I can observe the data has been inserted to TableB by the trigger, but MobiLink does not upload any rows.

Am I missing something basic here :-)

Thanks, Bill

mobilink trigger

asked 13 Nov '09, 19:16

Bill Aumen
2.1k●35●47●75
accept rate: 16%

edited 15 Nov '09, 10:31

Breck Carter
32.5k●541●726●1050

flat view

One Answer:

active answers oldest answers newest answers popular answers

AFAIK, the MobiLink extended option "SendTriggers" (dbmlsync -e "st=on") will control whether data modifications from triggers (and cascading actions) are included in the upload stream.

By default, it is set to "off".

HTH Volker

permanent link

answered 13 Nov '09, 20:28

Volker Barth
40.2k●361●550●822
accept rate: 34%

yep, I was forgetting something basic! Thanks Volker.

(13 Nov '09, 22:17) Bill Aumen

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

mobilink ×371
trigger ×79

question asked: 13 Nov '09, 19:16

question was seen: 2,597 times

last updated: 15 Nov '09, 10:31

SAP SQL Anywhere

Will a publication upload trigger-generated data to Mobilink?

Follow this question

Related questions