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
1
vote
0 answers

Can Formmule script be set to report cumulative student lates-to-classes?

I am using Formmule to report student lates-to-classes. I'd like the script to flag and report to the student, parents, and school administrators the total number of absences once they reach 3, for example, then 6, 9, etc. Is this possible to do?…
Brian
  • 11
  • 6
1
vote
0 answers

Firing a trigger at regular intervals of 1 minute

I have written a trigger code. It is given below. create trigger trg1 on tb_g2 for insert as begin declare @mid int select @mid=mid from tb_g2 where biddate>'2014-05-03 20:50:52' insert into tb_g5(pid) values(@mid) end EDIT create trigger trg1 on…
njnjnj
  • 978
  • 4
  • 23
  • 58
1
vote
1 answer

Can windows eventtriggers be used for trivial events?

In an application I am making, I want to know when a user copies a file or clicks the start button. Those actions would be considered too trivial but they carry some importance in my application. Yesterday, I received a comment Getting notified of…
user1411148
1
vote
1 answer

How to write an event trigger which send alerts to a JMS Queue

Is there any example where, we can trigger an event to send messages to JMS Queue when a table is updated/inserted ect for MYSQL/Postgre?
poohdedoo
  • 1,258
  • 1
  • 18
  • 42
1
vote
2 answers

ZF2 trigger service or event in background

maybe anybody knows how to best tackle this problem. I have a ZF2 application in which a client can upload a file. The file contains orders and then needs to be processed. If I trigger an event that starts processing this file right away, the…
Isolde
  • 626
  • 6
  • 12
1
vote
5 answers

How Can I Animate Mouse Over Event Using WPF Triggers For a Tab Item?

I have overriden tabitem template and created my own custom style. however, I'm not sure how to write event triggers for mouse over event. Sorry for the late response, I am not getting a notification for comments (maybe this should be…
immuner
  • 243
  • 1
  • 7
  • 18
1
vote
2 answers

Accurev Triggers for Security, Stream Management and JIRA Integration

About 6 months ago we started using AccuRev with JIRA for our source control and issue management, but there are some obvious problems, like a lack of security, everyone can pretty much do anything, like lock and unlock stream and change streams…
Jiri Klouda
  • 1,362
  • 12
  • 25
1
vote
1 answer

MySQL update from select and further select and updates

Currently trying to find a way to do the following inside some form of loop (preferably without a performance hit on database). I have 3 tables user_hours, user_calendar and hours_statistics. I need to first do: SELECT user_calendar.date_start, …
MarkH
  • 105
  • 1
  • 11
1
vote
3 answers

Oracle Triggers Update based on orderlines fulfilled how to avoid mutation error

for a typical products & shipping Database I am exploring the best way to run a trigger that: When an order line is set to 'Complete', a trigger is ran that: Looks for any other order lines for that order. If all other order lines for that order…
user885983
  • 458
  • 4
  • 9
0
votes
1 answer

Maintain column relationships in MySQL

I have a table called modules and I want to enforce the following logic, but I am not sure the best way to do it. I was thinking adding an update and insert trigger, but having issues with the trigger code. If the module_sub_id greater than ZERO,…
jlimited
  • 685
  • 2
  • 11
  • 20
0
votes
1 answer

EventTrigger in Xaml

I am trying to add an eventtrigger inside my style but for some reason it is not working. It is throwing me an error of {"Value cannot be null.\r\nParameter name: routedEvent"} My goal is to add a fix logic of my control in its KeyDown event,…
maridob
  • 651
  • 6
  • 22
0
votes
2 answers

jquery trigger: how can I use it to trigger a link when the page is loaded

How can I use trigger() to trigger the click event on a particular link only? for instance, I have this menu,
  • 1
  • 2
  • Run
    • 54,938
    • 169
    • 450
    • 748
  • 0
    votes
    1 answer

    How to translate event driven code?

    I'm mostly C# developer and I'm recently working on some Android project. I have to implement some custom written events in Android, but I'm not sure how to do that. I wrote a C# code for what I want to do, so if anyone can help me with translating…
    delux
    • 1,694
    • 10
    • 33
    • 64
    0
    votes
    1 answer

    eventocommand not working

    I am making one application in MVVM using Galasoft MVVM Light toolkit. However i can't make EventToCommand make it work with Telerik Context Menu. Here is my code :-
    TCM
    • 16,780
    • 43
    • 156
    • 254
    0
    votes
    1 answer

    Triggering default action in jQuery event handlers BEFORE further processing

    I'm implementing a workaround for the 'can't upload files using AJAX' problem (in short, the form targets an iframe, and I want jQuery to then grab the content of the iframe and process it). At the moment, I have a submit handler which is called…
    narnianUK
    • 91
    • 1
    • 1
    • 3