Triggers


Articles

Sort by:
DateTitleAuthorType
9 Jul 2003 How to reset a generator.
A breif description of how to use the GEN_ID function to reset a generator. Plus a link to a document describing how to use the SET GENERATOR statement to do the same,
Ben Matterson FAQ
30 Jun 2003 Locking a record against deletion.
How to ensure that a record is not deleted from a table.
Ben Matterson FAQ
15 Oct 2002 Aborting record deletion in a trigger.
How to abort deletion of a record based on some criterion.
Ben Matterson FAQ
24 Jul 2000 Too Many Concurrent Executions of the Same Request
Caused by recursive triggers
Borland Staff FAQ
24 Jul 2000 general sql error: violation of foreign key constraint
he problem occurs because you are using the incorrect type of Trigger
Borland Staff FAQ
24 Jul 2000 How do I assign a generator to populate my primary key with triggers.
Generators are assigned to keys via triggers
Borland Staff FAQ
24 Jul 2000 How to implement a cascading delete with a trigger.
How to delete a record from a from both the master table as well the associated records from the detail table using a trigger.
Borland Staff FAQ
24 Jul 2000 Changing Owner of Database
Only SYSDBA or the owner of a table can create a trigger for a table
Borland Staff FAQ
24 Jul 2000 How are Triggers loaded and executed with InterBase v5.x
Order in which triggers are loaded (and hence executed)
Borland Staff FAQ
24 Jul 2000 An example of logging user activity against tables
Logging user activity can be done via triggers.
Borland Staff FAQ
24 Jul 2000 How to do an OR condition within an IF statement
You need to put the entire expression containing the OR condition in parenthesis.
Borland Staff FAQ
24 Jul 2000 Error when running isql script: -Token unknown - line 4, char 2 -when
Error occurs due to improperly written Stored Procedure or Trigger
Borland Staff FAQ
12 Jul 2000 Introduction to InterBase Stored Procedures and Triggers
The heart of client/server application development is using stored procedures and triggers effectively. This session will provide a complete, practical, example-based introduction to these topics.
Conference Speaker White Paper

Server Response from: ETNASC01