| Sort by:
|
|
|
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
|
|
|
Connect with Us