Chapter 8: Defining Triggers


Overview

A trigger is similar to a stored procedure in many respects. Like a stored procedure, a trigger is executable code that is installed on, and executes on, the server. However, unlike stored procedures, triggers are not executed by client applications. Instead, they are executed by the server in response to row-level data operations.

In this chapter, you will learn how to create and register triggers. We begin with a look at the types of triggers that are supported by the ADS (Advantage Database Server). Next, you will find examples of a trigger written in SQL, Delphi, C#, and Visual Basic .NET. Finally, you will learn how to register and configure triggers.

Note

If you are unfamiliar with SQL, you may also want to refer to Chapters 9, 10, and 11 while reading this chapter.




Advantage Database Server. The Official Guide
Advantage Database Server: The Official Guide
ISBN: 0072230843
EAN: 2147483647
Year: 2002
Pages: 129

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net