Foreign Key Enforcer SQLite foreign key enforcer for Adobe AIR
Download

Foreign Key Enforcer Ranking & Summary

Foreign Key Enforcer Tags

generate SQL query SQL query generate query parse parameter

Foreign Key Enforcer Description

SQLite foreign key enforcer for Adobe AIR The Foreign Key Enforcer application is basically an AIR program that generate SQL queries based on the key data that you fill in. FOREIGN KEY constraints are parsed but are not enforced in SQLite. However, the equivalent constraint enforcement can be achieved using triggers. Unfortunately you would have to write triggers for the Insert, Update and Delete operations for every Foreign Key in your database.It will obviously be a tedious task prone to many human errors to create all the triggers. So, the Foreign Key Enforcer application generate these triggers after parsing some parameters to the application.Here are the main options of the application: Relationship name: set the name of the trigger that best describes the relationship between the primary key and the foreign key. FK_FOREIGN KEY TABLE_PRIMARY KEY TABLE. If this format is used, the application can also help predict the table and column names for the relationship by clicking on the “I” button. Format as Readable: this option helps you format the generated code as readable or in a single line. Push Statement: This option helps you generate the codes using this array method. Here are some key features of "Foreign Key Enforcer": · Easy deployment (AIR / Flash Player Technology) · Cross-Platform ( Windows, Linux, Mac ) · Embedded Open source database (SQLite) · Beautiful User Interface Requirements: · Adobe AIR

Foreign Key Enforcer Related Software