Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our news
Partners
Testimonials
Jacob Lyohne, Director of Development: "Regarding implementation, it is pretty self-explanatory and the SQLite Maestro manual is helpful for review and reference. We also found the on-line documentation useful and the software support staff readily available to answer our questions. Reports are very easy and quick to run and can be broken down into any number of statistical combinations".
Gianmarco Brundo: "I have purchased SQLite Mestro and SQLite Data Wizard, your products are very good".

More

Add your opinion

Customers
Download Buy

SQLite Maestro online Help

Prev Return to chapter overview Next

Specifying trigger properties

Type (Before, After)

Determines whether the function is called before or after the event.

 

Event

One of Insert, Update, or Delete; this specifies the event that will fire the trigger.

 

Field list

This is available when Update of option is selected in Event select. You can specify which fields are to be updated to cause the trigger being fired.

 

When expression

If you supply when expression, the SQL statements specified as trigger steps are only executed for those rows for which the WHEN clause is true. If no WHEN clause is supplied, the SQL statements are executed for all rows.



Prev Return to chapter overview Next