Mergeant manual

Vivien Malerba

This documentation is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

For more details see the file COPYING in the source distribution of GNOME.


Table of Contents
Foreword
1. Introduction and overview
1.1. What is Mergeant?
1.2. Data manipulated in Mergeant
1.2.1. Automatically known database informations
1.2.2. User provided information
1.3. Making queries
1.3.1. Data definition queries
1.3.2. Data manipulation queries
1.3.3. Using a console for direct access
1.4. Document handling
1.5. Execution environment
1.6. A practical example
2. Mergeant's user interface
2.1. Main window
2.2. Menus description
2.3. SQL Console
3. Tables relations
3.1. Generalities on relations
3.2. Creation and deletion of relations
3.3. Global view of the relations
4. Data manipulation queries
4.1. Making SELECT queries
4.1.1. The 'Objects' tab
4.1.2. The 'Automatic dependencies' tab
4.1.3. The 'Where clauses' tab
4.1.4. The 'Options' tab
4.1.5. The 'Test SQL' tab
4.1.6. Last comment on SELECT queries
4.2. Other kind of DML queries: INSERT, UPDATE and DELETE
4.2.1. Grid (or tabular) view
4.2.2. Forms
5. Plugins usage
5.1. Why plugins?
5.2. Defining plugins usage
5.2.1. Usage summary tab
5.2.2. Data types tab
5.2.3. Individual objects tab
6. Creating reports
7. Database structure and objects management
List of Figures
1-1. Summary of the execution environment of Mergeant
1-2. Diagram to summarize the relations of the example database
2-1. Mergeant's main window
2-2. Main Mergeant screen
2-3. SQL console
3-1. Tables properties' dialog showing a relation
3-2. Global dialog for relations
4-1. Example of a query edition dialog
4-2. Objects tab of the query edition dialog
4-3. Joins tab of the query edition dialog
4-4. Conditions tab of the query edition dialog
4-5. SQL tab of the query edition dialog
4-6. View and Form properties edition
4-7. Example of grid (or tabular) view
4-8. Example of form view
5-1. Plugins usage summary tab
5-2. Plugins data types tab
5-3. Plugins individual objects tab