IBExpert Functional Overview
Main Menu Level
	Sub Menu Level
		Detail
			Description
Database
	Database Registration Info		Edit Informations to work with an InterBase Database (Details see below)
	Create Database		Create a new Database on a remote or local Server
	Drop Database		Delete database File(s) on a remote or local Server
	Recompute Selectivity of all Indices		Automatically recompute this important Value for all Indices
	Recompile all Stored Procedures		Automatically recompile all Procedures (improves sometimes performance)
Edit
	Load from File		Open a File in the sql Editor
	Save to File		Save Editor Text to a file
	Print Preview		SQL Command Printable Preview
	Print		Print SQL Command
	Page Setup		Printer Setup
View
	Database Explorer		Show/Hide Left Window where all Database Objects are organized (F11) (see Details below)
	Status Bar		Show/Hide Status Bar with Informations (See Details below)
	Tool Bars		Show Hide Toolbars for Database, Tools, Edit, New DB Objects
Options
	Environment Options		See Details below
	Editor Options		Set Details of the Editors Behaviour
	Visual Options		Set Visual Options
	Keyboard Templates		Set Templates (just write the name in the editor, press space and it is replaced as defined)
	General Templates		See Details below
	Object Editors options		See Details below
Tools
	SQL Editor		Open the SQL Editor to Enter SQL Commands (see details below)
	New SQL Editor		Open a new Editor Window
	Query Builder		Open the Query Builder to create complex Selects (See details below)
	Script Executive		Open a SQL Windows to run multiple SQL Command, Script Files
	SQL Monitor		Monitor all Operations (must be activated in Toolbar)
	Search in Metadata		Find any string in the objects metadata and show a list with all found objects
	Extract Metadata		Extract the selected Metadata to a script file, also with Data Inserts possible (see details below)
	Print Metadata		Print the selected Metadata as a Report
	User Manager		Add/Edit/Delete Users (path to Servers isc4.gdb must be set in Database Registration Info)
	Grant Manager		Visually Grant/Revoke Rights to all Objects/Users on Objects/Columns
	Localize IB Messages		Translate the IB Messages File
	Localize IB Expert		Translate IBExpert to another language (current availble:english, german, russian, french)
	Report Manager		Integrated Report Engine with Crosstable Suppport and much more (See details below)
	Blob Viewer/Editor		See Data of any Blob field converted in different formats (images, rtf, hex,…)
	Database Designer		Entity Relation Ship Diagram with Reverse Engineering (See Details below)
	Test Data Generator		Integrated Wizzard to fill the database with Test Data
Services			Some Services are only availble, when the server supports the Services API
	Backup Database		Backup Wizzard
	Restore Database		Restore Wizzard
	Server Properties/Log		Get Informations about the server, such as Version, Path Info, Open Database Files,…
	Database Validation		Validation Wizzard
	Database Statistics		Database Statistcis with Detail Summary
	Database Properties		Set Database Properties such as Dialect, Sweep Interval, Forced Writes, Read Only, Cache Memory and List Active Users
	Database Shutdown		Shutdown Wizzard
	Database Online		Bring Database back Online
	Communication Diagnostics		Simple Network Test, See Details below
PlugIns			These PlugIns must be downloaded seperatly and the Dlls must be placed in PlugIn Directory (Delphi Example availble)
	IB Database Comparer		Third Party PlugIn to compare the metadata of two Databases
	IB-Access Converter		Third Party PlugIn Wizzard to convert an MDB Database to IB
	Test Data Generator		Delphi Sourc Code Example, how to write a Plugin for IBExpert
	IBE Pascal Scripter		Simple Pascal Script PlugIn
	IB Logmanager		Third Party Logmanager from Thomas Steinmaurer (commercial, www.iblogmanager.com)
	InterBase Data Pump		Third Party Datapump to pump Table from/to IB and from any BDE Source
Windows			Windows Management
Help			Help Files are not finished yet
Main Windows
	Sub Window
		Pop Up Menu
			Description
Status Bar
	Editor Position		You can see the actual Cursor Position in the Status Bar
	Active Database and Dialect		The Active Database and used Dialect is shown in the Status Bar
	RDB$Format Change Warning		The internal IB Limit of max. 255 Metadatachanges per Table (before Backup/Restore is required) is displayed here as a warning
Database Explorer
	Databases
		New Database Folder	A Database Folder can be created to organize the registered Databases
		Edit Database Folder	The Name of the Database Folder must be changed by Select the Folder and Press Return
		Delete Database Folder	Only Empty folders can be deleted
		Autogrant Privileges	Some objects can be automatically granted to all users on Mouseclick
		Goto Database	Show All Database Entries in one List for Opening
		Goto Object	Show all Database Objects in one List for Opening
		Refresh	Reload all Objects (Sometimes disconnect/connect is the better way)
		Database Registration Info	See details below
		Recompute Selectivity of all Indices	Automatically recompute this important Value for all Indices
		Recompile all Stored Procedures	Automatically recompile all Procedures (improves sometimes performance)
		Show SQL Assistant	Show/Hide SQL Assistant (shows details for selected Object in Database Explorer, such as fieldnames, that can drag/dropped into SQL Editor)
		Show Object Description	Show/Hide Object Description in a column in the Database Explorer
		Inspector Page Mode	Another View in the Database Explorer
		Hide Disconnected Databases	Don´t show disconnected Database Entries
		Domains	Create, Edit and Delete Domains
		Tables	Create, Edit and Delete Tables (See Details below)
		Create SIUD Procedures	Wizzard to create Procedures for Select, Insert, Update and Delete for a Table
		Views	Create, Edit and Delete Views (See Details below)
		Procedures	Create, Edit and Delete Procedures (See Details below)
		Triggers	Create, Edit and Delete Triggers (See Details below)
		Generator	Create, Edit and Delete Generators
		Exceptions	Create, Edit and Delete Exceptions
		UDFs	Create, Edit and Delete UDFs
		Roles	Create, Edit and Delete Roles
	Project		Project View can be created for a Database to organize objects in your own Tree Structure
		New Folder	Create a folder
		Add Object	Add any Object in this folder (The Object must already exists)
		Remove Object	Remove this object from this folder (but it is not dropped)
		Find Objects in Explorer Tree	The actual object should be activated in the Databases Tree
		Create User Item from Clipboard	Create a simple Text Entry with the actual text from the Clipboard (can be changed in SQL Assistant Window)
		Copy User Item to Clipboard	Copy this items Text back to Clipboard
	Windows		Overview of all actual opened Windows
		Find Objects in Explorer Tree	Activate the object behind the open Window in the Database Explorer
	Recent		Overview of all recently opened Database Objects
		Delete Objects	Remove an Entry from this List
		Find Objects in Explorer Tree	Activate the selected object in the Database Explorer
		Clear Recent List	Delete all Entries
	Help		Some Help Entries are visible, but not all are updated (should be finished with Version 2 final)
		Contents	Tree Overview of all Help Topics
		Index	Keywordlist
	SQL Assistant		Detail Window for Selected Object (i.e. Fieldnames and Types, Database Server and File Info, …)
SQL Editor
	Specials		Some features, that are not visible on the first look
		Code Insight/Completion	Integrated Code Completion System, Details can be changed in "Options-Environment Options"
		Hyperlinks	Every Object Name can be double clicked to open the Object Editor
	Toolbar
		Previous Command	reload the last SQL Command
		Next Command	After reloading the last command, the next Commands can be reloaded
		Execute	Execute the actual SQL Command
		Execute and Fetch all	Execute the actual SQL Command and fetch all Records (better results in Performance Analysis, but takes more time)
		Prepare	Only Prepare the Query to see the used Plan and check the Command, but not Data is transmitted
		Visual Query Builder	Open the Visual Query Builder Window to create complex select Statement
		New Query	Create a new Query (Queries can be selected by click on the number below the editor)
		Delete Query	Delete the actual query from the Querylist
		Delete All	Delete all Queries from the Querylist
		Export Data	Wizzard to export the actual Result Set into different Format, such as MS Excel, MS Word, RTF,HTML,Text, CSV,DIF, SYLK,LaTeX,XML,Clipboard
		Export Data into Script	Wizzard to create an Insert into …. Script file for the actual Result set
		Create View from select	Wizzard to create a View for the actual SQL Command with the same result
		Create Procedure from select	Wizzard to create a Stored Procedure for the actual SQL Command with the same result or in internal Variables
		Count Records	Count the Records in the actual result set (select count(*) from …..)
	Edit
		Toggle Bookmarks	Set/Unset Bookmark
		Goto Bookmarks	Locate Bookmark
		Comment Selected	The Selected Text is automatically commented
		Uncomment Selected	The Selected Text is automatically uncommented
		Convert Charcase	Automatically convert the text to upper- or lowercase
		Load from File	Load a SQL Command from a File
		Save to File	Save a SQL Command to a File
	Results		When a Select is executed, the Result Set will be displayed
		Adjust Column Width	All Columns are trimmed
		Set Null	This Column Value is set to Null (When it is a Live Dataset)
		Copy Records to Clipboard	The Dataset is copied to the Clipboard
		Copy current Record to Clipboard	The current Record is copied to the Clipboard
		Copy Current Record as Insert	The current Record is copied to the Clipboard as an Insert Command
		Duplicate Record	The current Record is duplicated
		Group Field	Special Way to display Data in Grids (Choose options-environment options-grids-allow records grouping and drag/drop one or more columns to the header, but it requires a unique field in the result set)
		Sort	Click on any Column Header to display the data sorted ascending, sorted descending or unsorted
	Results
		Grid View	The typical View
		Form View	Another View, where a form is automatically created
		Print Data	Another View, that can be printed
	History		Display the last used SQL Commands in a list
	Plan Analyzer		Display the Query Plan as a Tree (with used table, fields, indices) and show in red color, where no index is used
	Performance Analysis		When a SQL Command is excuted, the performance Analysis shows all Data needed to optimize this Command
		Graphical Summary	Grapical Summary with Values, how many operations are needed on the displayed table and if an index is used (blue) or not (red)
		Reads	Same Information, but only for Reads
		Updates	Same Information, but only for Updates
		Deletes	Same Information, but only for Deletes
		Inserts	Same Information, but only for Inserts
		Additional	Non Graphical Overview of the Performance Issues, for example added Memory Changes, Read/Wrote Pages, Internal Fetches, Times, …
	SQL Editor-Logs		When loging is activated, the commands are logged here as a script.
Table Editor			Editor for Tables
	Toolbar
		Export Data	Same as in SQL Editor Result Set
		Export Data into Script	Same as in SQL Editor Result Set
		Print Table Metadata	Print Metadata Report for the current selected Table
		Create procedure	Same as SIUD Procedures
		Create view	Wizzard to create a View for the current Table with the same result and Trigger to make this view writable
		Prepare Table for Logging	Wizzard to log changes on Data (Insert/Update/Deletes) on Table/Columns (rightclick on Header to select all columns)
		Get Record Count	Count the Records in the current Table (select count(*) from …..)
	Fields
		New Field	Wizzard to add a new Field in the Table Structure
		Edit Field	Wizzard to Display/Edit the current Field Definition
		Drop Field	Drop the current Field
		Reorder Fields	Change the order of Fields
		Copy Fields list to Clipboard	Copy Fields list to Clipboard
	Constraints
		Primary Key	Wizzard to add/edit/drop a primary Key
		Foreign Key	Wizzard to add/edit/drop foreign Keys
		Checks	Wizzard to add/edit/drop Check Constraints
		Uniques	Wizzard to add/edit/drop Unique Constraints
	Indices
		Statistics	The internal Statistics Value called Selectivity of every Index is automatically displayed
		Recompute Selectivity of INDEX	Since the Selectivity is not updated automatically, it can recomputed manually for an Index
		Recompute Selectivity of all	or for all Indices
	Dependencies
		Depend on Table	All Objects, that have for example foreign Keys or fields from this Table used in a Trigger/Stored Procedure, are displayed here
		Table Depend on	All Objects, where this Table has references on, are display here
	Trigger		Add/Edit/Delete Trigger for this Table (See Details below)
	Data		Almost Similar to the Result Set from SQL Editor
	Description		All InterBase Objects have an internal Blobfield to describe it. This can be edited here
	DDL		See the Table as a complete SQL Script
	Grants		Add/Edit/Change all Priviliges for this Object
	Logging		When Table is prepred for Logging, all changed values are displayed here
View Editor			The View Edit is almost similar to the Table Editor, except some points
	SQL		The SQL Command for this View
	Fields		All Fields, but Read Only, because changes are only possible in SQL Window
	Version History		To Activate Version Control, simply open this Window and let IBExpert create needed objects
		Version	View/Delete all logged Versions of the View
		Compare Versions	Wizzard to Compare two View Versions
	Recreate Script		A Script to drop and create this View
	Plan Analyzer		similar to Table Editor
Procedure Editor
	Toolbar		Almost similar to Table/SQL Editor, except
		Lazy Mode	Display Header in Text or Wizzard
		Debug Procedure	Start this to Debug the Procedure (See details below)
	Edit		Edit the Stored Procedure Source Code
	Operations/Index Using		Show every internal Operation and analyze, if an index is used or not (red color)
	Parameters		Parameter Overview
	Version History		Similar to View Editor
Trigger Editor			Similar to Stored Procedure Editor
Debugger			Debugger for Stored Procedures and Trigger
	Toolbar
		Toggle Breakpoint	Breakpoint Handling
		Reset	Restart the Debugging
		Parameters	Set the Parameters (must be set manually before run the first Step Over(F8))
		Run	Run the procedure (only stop on break points)
		Pause	Hold execution
		Step Over	Step over to the next command
		(Trace Into)	Not yet implemented
	Info
		Parameters and Variables	Overview of all Valid Parameters and Variables and their current Values
		Watches	Watches Handling
		Last Statement	See the last executed statement
		Breakpoints	Breakpoints Overview
		Messages	Messages Handling
		Results	Result Set of Select/Suspend Procedures
Query Builder
	Builder
		Desktop	Drag/Drop Objects on the Desktop to add them to the result set
		Tables/Views	Usable Objects
		Link Options	Drag/Drop from one column to the other to link them, link details on double click
		Criterions	Add some more criterions to the command
		Selection	Change the Selection
		Grouping	Grouping
		Sorting	Sorting
	Edit		See the current SQL Command as Text
	Performance Analysis		See the current SQL Command´s Performance
Database Registration Info
	General		Set DB Path, Path to isc4, Username, Password (autologin), charset, …. Enable "Always Capitalize.." to be sure, that no lowercase is used)
	Additional		Autocommit, System Tables in Performance Analysis, Trim Char Fields in Grids
		DB Explorer	Show System Objects in Explorer, Show Details in Explorer (for example an index under a table)
		SQL Editor	History Count (the last n SQL Commands are stored in a file and can be reopened with Ctrl+P in SQL Editor, also after a restart)
	Log Files
		Metadata Changes	Log Metadata Chages to create a script with the same changes
		SQL Editor	Log SQL Editor to log all commands as a script
	Backup/Restore
		Files	Give this database file an always used backup filename
		Backup Options	Preset the options for backup
		Restore Options	Preset the options for restore
	Default Paths		Set Default Path for different Operation (Metadata Extract, Export, QuickSave, Parameters)
	Test Connect		Communication Diagnostics
	Copy Alias Info		Duplicate a Database Registration
Communication Diagnostics
	DB Connection		Set the complete Information to connect to a database and see the in Result window
	TCP/IP		Check TCP/IP working (ports, ping)
	NetBEUI		Check NetBEUI working
	SPX		Check SPX working
Script Executive			This Part is almost similar to the SQL Editor, except
	Toolbar
		Use current Connect	You can start a script without connect/create Database, when this Option is activated. All Operations are done in current Database.
	Script Explorer		Any Object, that is defined in the Script, is checked in the parser, to see errors, before the script must be executed
	Scripts		The Script Source Code
	Statements		The different Statements in the Script
Extract Metadata			Create a Script, that creates some or all Objects defined in the current Database
	Metadata Objects		Choose Objects, that the script should create
	Data Tables		It is possible, to add Data insert commands for all records in the Script
	Options		Settings to modify the script, Blob Export in Script File,…
	Output		The result Script
Print Metadata			Print some/all Metadata in a Report
User Manager			Visual User Manager to Add/Edit/Delete Users/Roles  and Membership in Roles
Grant Manager			Visual Grant Manager to add or Remove Rights to User/Objects on Objects, Multiple Entries can be made by right click on Header/Row
Report manager			The integrated Report Manager
	Database Report Storage		To store the Report in the Database, open the Database and doubleclick this Entry in the Report Explorer
	Toolbar
		Open Report from File	A Report can also be stored in a *.frf File
		New	Create a new Report in the Selected Area(Database/Folder)
		Show Report	When a Report is Selected, it is shown in the Preview window.
		Design Report	Start the Database Designer
		Pages	Pages Navigator (First Page, Previous Page, Next Page, Last Page)
		Save	Save the current Report in different Formats, such as RTF, Html, PDF, …
		Print	Send the Report to the Printer
	Report Designer
		Add Dataset	When designing a Report, a Dialog Form should be added and a Database/Query can be placed there as Datasource for Report Band/Fields
Blob Viewer/Editor
	Toolbar
		Load	Load any File into the current Blob Field
		Save	Save the data from the current Blob Field to a file
		Navigator	Navigate in the current Selected Dataset
	Format
		Text	Display current Blobfield as Text
		Hex	Display current Blobfield as Hex
		Picture	Quick Butmap, Icon, Gif, Jpeg, Bitmap, WMF
		RTF	Display current Blobfield as RTF
		Webpage	Display current Blobfield as Html
General Templates			Set User Defined Templates used by IBExpert
	Autoincrement Fields		When a Autoincrement Field in Table Editor is created, the following Templates are used: Generator Name, Trigger Name,  Procedure Name, Trigger Text, Procedure Text
	Constraint Names		When a Constraint is Created, the following Templates are used:Primary Key, Foreign Key, Check, Unique
	Indices		Template used for create a new Index Name
	New View		Template used for create a new View Name
	New Trigger		Template used for create a new Trigger Name
		Standard Mode	Template used for create a new Trigger Text, when created in Standard Mode with Header
		Lazy Mode	Template used for create a new Trigger Text, when created in Lazy Mode without Header
	New Procedure		Template used for create a new Stored Procedure Name
		Standard Mode	Template used for create a new Stored Procedure Text, when created in Standard Mode with Header
		Lazy Mode	Template used for create a new Stored Procedure Text, when created in Lazy Mode without Header
	View from Table
		View Name	Template used for create a new View Name created for a Table
		Before Insert Trigger Name	Template used for create a new Insert Trigger Name
		Before Update Trigger Name	Template used for create a new Update Trigger Name
		Before Delete Trigger Name	Template used for create a new Delete Trigger Name
	SIUD Procedure
		Select Procedure Name	Template used for create a new SIUD Select Procedure
		Insert Procedure Name	Template used for create a new SIUD Insert Procedure
		Update Procedure Name	Template used for create a new SIUD Update Procedure
		Delete Procedure Name	Template used for create a new SIUD Delete Procedure
Object Editors Options			Some Editor Settings
	Domains Editor		Old Style, Systemtables
	Tables Editor		Restore active Page, Set Active Page
	Views Editor		Restore active Page, Set Active Page
	Procedures Editor		Lazy/Standard Mode, Syntax Check before Compiling, Recompiling dependent Objects
	Triggers Editor		Lazy/Standard Mode, Position Check
Database Designer
	Toolbar
		Reverse Engineer	When you want to create (reverse engineer from existing DB) a complete Model of the database, this is the fastest way
		Generate Script	Create a SQL Script from the current model
		New	Start the Work on a new Model
		Open	Open an existing Model
		Save	Save the current Model
		Print	Print the current Model
		Zoom	Set Zoom in Percent
		Select	Selector activate
		Zoom in	Zoom in on click in Model
		Zoom out	Zoom out on click in Model
		Add Table	Add a Table to the Model (doubleclick on any Table to it)
		Add Link	Add a link (Drag/Drop from source Table to target Table)
Environment Options
	Preferences		Choose between MDI and SDI Mode (Restart required), Multi Instance, Sounds, Save Desktop, Maximize first Child
	Confirmations		Disable/Enable Confirmations for different Operations
	Tools		Autogrant, Inplace Object Editor
		DBExplorer	Objects Descriptions, Double Click expanding
		SQL Editor	Fetch All, Open Results, Disable Performance Analysis
		SQL Script Options	Script Error handling
	Font		Font Settings
	Transactions		Transaction setting
	Grid		Grid behaviour, Stripy Grids (colored rows), Textblobs showing, Allow Record Grouping
		Colors	Set Grid Colors
		Display Formats	Display Formats for Integer, Float, Datetime, Date, Time Fields
	Additional Help		Add external Help files in IBExperts Help Menu
	Additional Tools		Add external Tools in Tools Menu, Variables are for example %DB_FILE_NAME% d:\my_avx.gbk -user %USER_NAME% -password %PASSWORD%
	Disabled Names		Object Names, that should not be visible
	Associations		IBExpert can associate File type *.gdb and *.sql, that are opened with IBExpert, when double clicked in Windows Explorer