Progress
DataServer for
Microsoft SQL Server
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 MSS data sources. 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 MSS data source and the operation (INSERT, UPDATE, DELETE) executes.

Triggers for Progress databases and MSS 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 MSS data sources are independent, they might affect each other based on the kind of transaction your application is executing.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095