Triggers Questions


Trigger
What is the use of the trigger?

Answer Question   |  September 21, 2012  9:02 AM
SQL Trigger, Triggers
asked by:
25 pts.

Trigger over table that uses transaction inserts
I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the [...]

Answer Question   |  February 28, 2012  5:23 PM
iSeries, JDBC, SQL INSERT, Triggers
asked by:
KSC
90 pts.

Execute trigger only on update of selected fields
We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately when removing a SQL trigger [...]

Answer Question   |  January 4, 2011  11:00 AM
AS/400, AS/400 triggers, COBOL, SQL Trigger, Triggers
asked by:
810 pts.

Create trigger using iSeries Navigator
I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it [...]

Answer Question   |  December 2, 2010  2:28 AM
AS/400 triggers, iSeries Navigator, SQL, Triggers
asked by:
5 pts.

How do I create a trigger in VB 6?
HOW TO CREATE A TRIGGER IN VB6

Answer Question   |  October 1, 2010  3:57 AM
Triggers, VB, VB 6, Visual Basic, Visual Basic 6
asked by:
280 pts.

After trigger select from other tables using joins
Is it possible to create a trigger on table A if there is an insert, update, or delete then fire the trigger but in addition to the changes in table A I want to capture values from table B,C,D,E…. even if those records had no action applied to them. I tried declaring variables from the [...]

Answer Question   |  July 30, 2009  3:48 PM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers
asked by:
5 pts.

Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)
CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record ( field1 ae_dt526.field1%TYPE, action tab1_audit.action%TYPE, field13 tab1_audit.field13%TYPE, blanket_ind tab1_audit.blanket_ind%TYPE ); TYPE t_change_tab is table of t_change_rec; g_change_tab t_change_tab [...]

Answer Question   |  February 2, 2009  11:39 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers
asked by:
APB
10 pts.

How to call trigger stored in database using Oracle Forms
how to call trigger stored in database using oracle forms

Answer Question   |  November 12, 2011  9:47 AM
Oracle development, Oracle Forms, Oracle triggers, Triggers
asked by:
5 pts.

Update a field in one table after the change on a field in another table using a trigger in SQL
I have a WODet table and after the field “Complete” is changed to “True” I need to update my SODet table field “UD3″ to “True” using a trigger in SQL where dbo.SalesOrderDetails.SalesOrderDetailID = dbo.WorkOrderDetails.SalesOrderDetailID Thank you in advance

Answer Question   |  December 18, 2008  7:08 PM
SQL, Triggers
asked by:
40 pts.

Writing a hidden trigger against a SQL table
How do I write a hidden trigger against a SQL table?

Answer Question   |  December 13, 2008  7:48 PM
SQL Server tables, Triggers
2,585 pts.

SQL Server trigger , insert result of multiple where clause into a variable
Hi All, I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one? For example (Working one) SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value) But I [...]

Answer Question   |  November 12, 2008  8:23 AM
SELECT statement, SQL, SQL variables, Triggers
asked by:
20 pts.

Prevent Update in DB2 SQL External Trigger Program
I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a [...]

Answer Question   |  November 6, 2008  4:29 PM
AS/400, DB2, SQL, Triggers
asked by:
25 pts.

Triggering a stored procedure from C#
how to tigering a sp from c#???

Answer Question   |  November 23, 2008  5:24 AM
C#, Stored Procedures, Triggers
asked by:
10 pts.

Explaining triggers in SQL Server 2005
Can you explain to me the syntaxes of triggers used in SQL Server 2005? Could you also give me a simple example of a trigger?

Answer Question   |  October 14, 2008  6:52 PM
SQL Server 2005, syntax, Triggers
2,585 pts.

Trigger statement
sample trigger : create trigger trig_sample on table for insert,update as update table go now, the statement inside the trigger is to update the same table . will the trigger keeps on firing and thus cause and internal error??

Answer Question   |  September 10, 2008  6:19 AM
Database programming, Triggers
asked by:
20 pts.

Trigger programs
In a trigger program, is there a way to retrieve the program name that initiated the event?

Answer Question   |  August 6, 2008  2:17 AM
Triggers
asked by:
mcg
15 pts.

Error in SQL coding
I am having a specific problem with coding in SQL, and I was curious if you could give me any advice. I have entered this code: CREATE TRIGGER UpdateAfterPayment On SupplierTransactionDetails For Insert, Update, Delete As Update S If i.DebitValue>0 S.Balance = S.Balance + i.DebitValue else S.Balance = S.Balance – i.CreditValue from SupplierTransactionHead H, Suppliers [...]

Answer Question   |  August 4, 2008  2:31 PM
Code, SQL, Triggers
2,585 pts.

How to create a trigger for updating a table for a quantity decrease?
How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for [...]

Answer Question   |  July 16, 2008  3:48 PM
Oracle development, Triggers
asked by:
190 pts.

How to find out what is happening in a Database?
We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database’s tables. All I can report is that an insert, update or delete has occurred, the Date and [...]

Answer Question   |  July 15, 2008  11:01 PM
SQL Server, SQL Server logs, Temp Tables, Triggers, Unknown processes
asked by:
5 pts.

How to prevent SQL update trigger from firing on insert?
Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don’t want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don’t [...]

Answer Question   |  April 23, 2008  5:34 PM
SQL Server, SQL Server 2005, T/SQL, Triggers
asked by:
5 pts.