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

asked 13 Nov '09, 19:16

Bill%20Aumen's gravatar image

Bill Aumen
2.0k294473
accept rate: 16%

edited 15 Nov '09, 10:31

Breck%20Carter's gravatar image

Breck Carter
27.1k424582831


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%20Barth's gravatar image

Volker Barth
29.6k294444650
accept rate: 32%

yep, I was forgetting something basic! Thanks Volker.

(13 Nov '09, 22:17) Bill Aumen
Your answer
toggle preview

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

Question tags:

×279
×59

question asked: 13 Nov '09, 19:16

question was seen: 1,173 times

last updated: 15 Nov '09, 10:31