Unanswered: Triggers in windows application ^_^!!!
I have created a windows application with visual c++ 6.0 which connects to a database.
The application executes SQL queries and I want to set some triggers or the insert, update and delete queries.
However, Where should i place my triggers?
// Open the database
a trigger is a database object that is stored in the database.
If you use Oracle, connect against the Oracle database and use the CREATE OR REPLACE TRIGGER command to insert a trigger to a table or a view.
You can specify different types of triggers for example a trigger that only fires when inserts or update or deletes happens.
You can even set triggers on special DDL events like logon logout, create tabla and so on.
If you want to create trigger with a dialog based application, use AlligatorSQL and connect against your database. Click on your table in the schema and select the element trigger root. Press ALT-I to get into the dialog trigger and enter your options and your PL/SQL code to be executes when the rigger will be fired.