Stack Overflow
Stack Overflow

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
0
votes
1 answer

How to know the date of modification of an SP?

Is it possible to know the date of modification and / or creation of an SP in PostgreSQL 9.4? I need to identify them to upload them next Deploy.-
Max
  • 538
  • 1
  • 6
  • 16
0
votes
1 answer

the event of onchange at select control at php, trigger issue

I used this select which show counteries

user3403964
  • 15
  • 3
0
votes
1 answer

Jquery auto trigger event on checkbox unchecks the control

Here is my html and javascript, want to auto check on click of button and oncheck want to trigger some more actions. Tried with 'click' and 'change' event
GANI
  • 2,013
  • 4
  • 35
  • 69
0
votes
1 answer

Google Sheet script to sort timestamp on form submit not working

I have a google sheet that needs to auto sort by the timestamp whenever a user submits a form response. I found a script that will do this but it only works when I run the script manually. The script is: function getSpreadSheet(){ var ss =…
Josh_S
  • 3
  • 1
0
votes
1 answer

Deleting records with mysql triggers

So my hosting provider has informed me that i can not use Events as i need a super privilege to access it. So i have tried to replicate the same code into a trigger and still have no idea how to get it working. i have a TIMESTAMP in my table called…
user3476504
  • 23
  • 4
0
votes
1 answer

How to open/close view from the XAML code of another view when specific event is risen?

How to open/close view from the XAML code of another view (using MVVM) when specific event is risen?
Mrg Gek
  • 906
  • 2
  • 10
  • 31
0
votes
0 answers

How to handle an ALTER TABLE RENAME?

Asuming I have a table myTable that stores: id | tableName --------------------- 1 | a 2 | b ... | ... I have event triggers for CREATE TABLE / DROP TABLE events that updates the table "myTable". Now I want to handle…
Jose Hermosilla Rodrigo
  • 3,513
  • 6
  • 22
  • 38
0
votes
1 answer

How can I resolve property conflicts in WPF when using Triggers?

I am trying to change the background of a button but the problem is it has three states - IsEnabled, IsPressed and Clicked. In default state when I press the button the background changes and then when I click the button, the button animates but…
chan
  • 3
  • 1
  • 3
0
votes
1 answer

Trigger onEdit Trigger through programmatic edit

I've built a spreadsheet that tracks form responses using the onSubmit trigger. This works well. I then want to display part of the spreadsheet on another spreadsheet, and have built a script that does this. In order to ensure the second…
Bryn Larkman
  • 23
  • 4
0
votes
1 answer

Function list not appearing in BI Publisher when adding event triggers

I'm trying to create an after-report trigger for my data model. I created the following package on my database: Package: create or replace PACKAGE CM_BILL_PRINT_PACKAGE AS P_TO_ACCT_ID CI_ACCT.ACCT_ID%TYPE; P_FROM_ACCT_ID …
AbrasiveToast
  • 1
  • 1
  • 3
0
votes
1 answer

In C# how can I dynamically create trigger on an image

I am trying to dynamically create images that will zoom in when you mouse over them. I found this blog post http://tozon.info/blog/post/2007/10/14/Three-ways-to-make-your-WPF-images-pop-out-on-MouseOver.aspx that shows how to do this using…
mike
  • 1,583
  • 1
  • 19
  • 35
0
votes
2 answers

WPF Usercontrol XAML Triggers not working

I am making an UserControl with XAML which is a simple border with a Dock Panel inside it. And inside the Dock there is an image and text bellow as properties ( i got that all figured out already). However i need the Border that contains everything…
Neffarion
  • 59
  • 1
  • 7
0
votes
3 answers

Trigger click event

I have below Javascript and HTML and I would like to trigger the click event to link with . I could not see the log "summary click" in console, what element I should trigger on? I want to show the result on detail section, so I…
Kelvin
  • 577
  • 7
  • 25
0
votes
0 answers

Why a value set in event does not come over to the NEW.value in triggers?

In my event I have : UPDATE Xdb.shop_product_m2m as m2m SET m2m.expired=1 WHERE m2m.expires <= now(); And I tried this in the update trigger for the 'shop_product_m2m' table as : SET NEW.modified = NOW(); IF NEW.expired =1 OR…
edam
  • 910
  • 10
  • 29
0
votes
0 answers

How to set up a user defined variable in events of MySQL and access from trigger for later use?

As the question implies I need to declare a @var = 1 variable in a MySQL events as : DELIMITER $ SET @check_before_update = 1 $ DROP EVENT IF EXISTS expire_product_from_shop $ CREATE EVENT IF NOT EXISTS expire_product_from_shop ON SCHEDULE EVERY…
edam
  • 910
  • 10
  • 29
1 2 3
4
5