Questions tagged [event-triggers]

Unlike a normal database trigger that fires before or after DML statements, an event trigger will fire at other database events, like the execution of DDL statements or when a database session is established.

Unlike a normal that fires before or after statements, an event trigger will fire at other , like the execution of statements or when a database session is established.

Use this tag for questions concerning the creation or use of such triggers.

70 questions
2
votes
1 answer

Woocommerce: All new completed orders to on-hold (COD in particular) and send only one on-hold email as a standard confirmation

I live and work in Japan. We have a small oyster company with limited resources and I am doing all the programming myself, but I have limited knowledge and skill. First time posting, sorry if this isn't a good question or I make a mistake...Thanks…
Cody
  • 436
  • 5
  • 13
2
votes
1 answer

UWP - pointer pressed not working

I am working on a Universal windows app. I added an EventTrigger to my listboxitems.
Kasper Due
  • 699
  • 7
  • 19
2
votes
1 answer

Is it possible to trigger the "do Select All" event with multiple events

In the icCube dashboards you can fire the event "do Select All" event in an icCube/Buttons widget. Unfortunately, you can only add one event as a trigger event. Is it possible to trigger the event also with other events. For example, you want that…
Arthur
  • 1,692
  • 10
  • 14
2
votes
1 answer

Google Scripts Edit Trigger

I have installed an Edit Trigger in a bound Apps Script Project, and the trigger is not firing when the document is edited. It will firing using a 'Simple Trigger' but because I'm using methods which require authorization, I need to stick with an…
2
votes
2 answers

MySQL: trigger with clause "instead of update"

I'm trying to create a database with history in mind (experience shows you'll have to do this one day or another). I've asked here database-design-how-to-handle-the-archive-problem but there's no better anser than the link here. My problem is about…
Olivier Pons
  • 15,363
  • 26
  • 117
  • 213
1
vote
1 answer

How can I have Sql Server 2005 asynchronously call a DOS batch file from a DDL trigger?

I created a batch file to run SqlMetal and generate Linq2Sql data classes, check into source control triggering a build, etc... I'd like to have this script run anytime there is a DDL change in Sql Server 2005. Running the batch file via…
TheSoftwareJedi
  • 34,421
  • 21
  • 109
  • 151
1
vote
1 answer

Is it possible to capture DDL events against a specific set of tables with PostgreSQL's event triggers?

Can I restrict an event trigger to only capture events when DDL is performed against a specific set of tables?
d4nielfr4nco
  • 635
  • 1
  • 6
  • 17
1
vote
0 answers

How can I check the time a cell was edited and set the time and date in other cells? Google script

I have spreadsheet and I'm basically going to use it for inventory tracking and management. In one sheet I'll have an app on my phone fill a list when it reads a QR code. In the second sheet there is also a list with the specific QR codes of…
Owlet
  • 47
  • 9
1
vote
1 answer

Custom Actions triggered by Parsed values in Python

I am looking to build or more preferably use a framework to implement custom Assertions in python. I am listing below potential input that will be parsed to trigger the various assertions on retrieved data assertValue : [ SOME STRING A ] …
IamSats
  • 21
  • 5
1
vote
1 answer

How to check difference in each on OLD.* to NEW.* column in a MySQL Trigger?

Since SQL does not have a FOR-EACH statement, how could we verify if there is a difference on each value from the OLD object to the NEW object in a AFTER UPDATE type TRIGGER without knowing the table columns [and table names]? Example today: CREATE…
NaN
  • 8,596
  • 20
  • 79
  • 153
1
vote
0 answers

Starting a Storyboard from ViewModel via ControlStoryboardAction doesn't work

I'm trying to start a storyboard animation from my viewmodel. The idea is that there is an animation every time my application receives a position update from a server later on, but for now it would be fine to have a proof of concept where I can…
Philip Feldmann
  • 7,887
  • 6
  • 41
  • 65
1
vote
1 answer

Trigger every 14 days starting on a specific date

I'm trying to trigger a spreadsheet in google sheets to reset itself every 14 days but I need it to start doing that on a certain date (it's for company time sheets not that that's relevant). Here's what I have that works, triggering every 14…
1
vote
3 answers

ZF2 events triggering

I have the following situation: I one of the application modules I trigger an event, in the same module I create an event listener which listen to that trigger via the shared event manager system, by this step all works fine, I tried to create more…
1
vote
1 answer

google apps script - form not automatically mailing spreadsheet response

I am new to Google Scripts but am getting the gist of it pretty quickly. I am trying to automate ordering of toner for our commercial printer. I set up a Google Form with 4 scale questions, one for each color (CMYK), with multiple choices from 1…
1
vote
1 answer

Getting a script to trigger when only a specific form is submitted - Google Script / Sheets / Forms

I feel like this should be so easy and obvious, but I cannot figure it out... I am working with 2 forms and 2 spreadsheets. Form 1 submits to Sheet 1. On Sheet 1, for each record, there is a link that takes the user to Form 2, which is half…