Table of Contents

Class TDmlEventClause

Namespace
gudusoft.gsqlparser.nodes
Assembly
gudusoft.gsqlparser.dll

The DML_event_clause lets you specify one of three DML statements that can cause the trigger to fire. the database fires the trigger in the existing user transaction.

public class TDmlEventClause : TTriggerEventClause, Visitable
Inheritance
TDmlEventClause
Implements
Inherited Members

Properties

ColumnList

Fire the trigger whenever an UPDATE statement changes a value in one of the columns specified after OF. @return

public virtual TObjectNameList ColumnList { get; set; }

Property Value

TObjectNameList

Delete

If it's true, fire the trigger whenever a DELETE statement removes a row from the table or removes an element from a nested table. @return

public virtual bool Delete { get; set; }

Property Value

bool

Dml_event_items 

public virtual TDummyList Dml_event_items { set; }

Property Value

TDummyList

Insert

If it's true, fire the trigger whenever an INSERT statement adds a row to a table or adds an element to a nested table. @return

public virtual bool Insert { get; set; }

Property Value

bool

TableName

table that DML statement act on. @return

public virtual TObjectName TableName { get; set; }

Property Value

TObjectName

Update

If it's true, fire the trigger whenever an UPDATE statement changes a value in one of the columns specified after OF. If you omit OF, then the database fires the trigger whenever an UPDATE statement changes a value in any column of the table or nested table. @return

public virtual bool Update { get; set; }

Property Value

bool

Methods

init(object, object) 

public override void init(object arg1, object arg2)

Parameters

arg1 object
arg2 object
Edit this page