Progress
DataServer
for ODBC Guide
Triggers
Triggers are code that an application associates with a data-source object and an action. For example, writing a record might cause code associated with that object or action to execute. The DataServer allows an application to execute triggers for both Progress databases (including the schema holder) and ODBC data sources (if the data source supports triggers). In an application that executes both types, the Progress trigger (CREATE, FIND, UPDATE, DELETE) executes first. If processing a Progress trigger results in a data-source request, the DataServer passes the request to the appropriate ODBC data source and the operation (INSERT, UPDATE, DELETE) executes.
Triggers for Progress databases and ODBC data sources are independent of each other. A data-source trigger that rolls back does not affect Progress triggers. Defining a trigger in Progress does not create a data-source trigger definition. A Progress trigger that rolls back does so independently of the data source’s transaction scope. Note, however, that although triggers for Progress databases and ODBC data sources are independent, they might affect each other based on the kind of transaction that your application is executing.
See the documentation for your ODBC data source to determine whether it supports triggers and, if so, for information on the kind of triggers it supports.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |