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.
If you are unfamiliar with SQL, you may also want to refer to Chapters 9, 10, and 11 while reading this chapter.