Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

I have plenty of tables that have triggers on them to update new inserts with supporting information.

Example - Insert into child table tableX with basic information, grabs information from parent table tableY and adds to the child record. These fields are then filled in with the defaults from the Parent for ease of use, but can be overridden at the child level rather than strictly inherited.

The issue is that there are also plenty of tables where the insert already has all the information (e.g. copy existing rows to a new year, copy from an existing system etc.)

Is there any syntax or feature that would behave similar to this:

Insert into tableX on existing skip with auto name NO TRIGGERS / PAUSE TRIGGERS


asked 07 Nov '16, 14:12

Siger%20Matt's gravatar image

Siger Matt
accept rate: 15%

No, but you can program for this situation. See my other answer on this topic.

permanent link

answered 07 Nov '16, 14:21

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

I knew I had seen it before, just couldn't find it in the search. Thanks Mark!

(07 Nov '16, 14:24) Siger Matt
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: 07 Nov '16, 14:12

question was seen: 1,713 times

last updated: 07 Nov '16, 14:24