The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

fire_triggers is a binary option: on or off. When off, triggers do not fire, but also you don't get any referential integrity checks or delete chaining. I'd like an option to turn off user-defined triggers, but preserve the RI actions.

The reason is that we have two apps simultaneously accessing the same db. The old app is heavily dependent on triggers. The new app is designed to NOT require triggers. We'd like to disable the triggers for connections initiated by the new app, but not lose the RI actions.

Pardon me if this is a repost: I posted yesterday but it didn't appear,probably because I had not yet validated my account here.

(PS: Hola to Breck and my other old buddies from the team!)

asked 24 Mar, 09:44

leotohill's gravatar image

leotohill
8625
accept rate: 0%

Welcome to a Charter Member of [TeamPS]... I wish there was a way to add 10,000 points to your account in recognition :)

(24 Mar, 10:00) Breck Carter
Replies hidden
2

I don't suppose you want to add a line of code to the top of each non-ri trigger?

IF VAREXISTS ( 'this_is_the_new_app' ) = 1 THEN RETURN;

and CREATE that variable in a login procedure if the connection is coming from the new application?

(24 Mar, 10:11) Breck Carter

The poster of that older FAQ would have probably seconded that suggestion:

http://sqlanywhere-forum.sap.com/questions/11984/on-delete-cascade-not-functioning

I do, too.


FWIW, the dbsrvX -gf server option might then have to be extended, as well. Note, it is a server, not a database option, so it effects all databases on the engine.

(24 Mar, 11:05) Volker Barth

Yeah, we did something similar in sql server. would rather not revise our thousands of triggers on 750+ tables but maybe we will.

(24 Mar, 11:21) leotohill
Replies hidden

I am curious, how do you develop and test the code that has thousands of triggers. Or they are isolated well from each other.

(25 Mar, 04:25) Vlad

> thousands of triggers

(25 Mar, 07:58) Breck Carter

The old app is in Powerbuilder and has been in active development for more than 20 years. It's big. Because the design of the app does not funnel updates through a single update layer, triggers are used to assure certain business functions. We have extensive test suites, mostly regression tests using automation tools.

(27 Mar, 10:14) leotohill
showing 3 of 7 show all flat view
Be the first one to answer this question!
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:

×60
×11
×4

question asked: 24 Mar, 09:44

question was seen: 127 times

last updated: 27 Mar, 10:14