Product Documentation

FairCom C# Stored Procedures

Previous Topic

Next Topic

Accessing Old and New Rows in Triggers

Triggers do not have IN, INOUT, or OUT parameters but may receive one or two rows depending on the definitions of REFERENCING, OLDROW, and NEWROW.

These rows are passed, when referenced, as SqlSpRow objects to the ExecuteSP method.

The methods of the SqlSpRow class can then be used to retrieve the definition and values of columns. As is the case with stored procedure result set columns, the generated code contains constants with the names of the result set columns and the values of the column index.