Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

SQL Anywhere 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
accept rate: 16%

edited 15 Nov '09, 10:31

Breck%20Carter's gravatar image

Breck Carter

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
accept rate: 34%

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 13 Nov '09, 19:16

question was seen: 2,596 times

last updated: 15 Nov '09, 10:31