<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>FlameRobin 0.8.6 Manual</title><meta name="generator" content="DocBook XSL Stylesheets V1.71.1"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="article" lang="en"><div class="titlepage"><div><div><h1 class="title"><a name="frrelnotes"></a><span class="application">FlameRobin</span> 0.8.6 Manual</h1></div><div><div class="author"><h3 class="author"><span class="firstname">Nando</span> <span class="surname">Dessena</span></h3></div></div><div><div class="author"><h3 class="author"><span class="firstname">Milan</span> <span class="surname">Babuskov</span></h3></div></div></div><hr></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="section"><a href="#d0e23">About this manual</a></span></dt><dt><span class="section"><a href="#frrelnotes-alphatest">About the ALPHA test program</a></span></dt><dt><span class="section"><a href="#frrelnotes-what-fr-is">What FlameRobin is</a></span></dt><dt><span class="section"><a href="#frrelnotes-what-fr-is-not">What FlameRobin is NOT</a></span></dt><dt><span class="section"><a href="#frrelnotes-who-we-are">Who we are</a></span></dt><dt><span class="section"><a href="#frrelnotes-license">License</a></span></dt><dt><span class="section"><a href="#frrelnotes-changes">What's new?</a></span></dt><dt><span class="section"><a href="#frrelnotes-installation">Installation</a></span></dt><dd><dl><dt><span class="section"><a href="#d0e81">General information</a></span></dt><dt><span class="section"><a href="#d0e105">Windows (Win32)</a></span></dt><dt><span class="section"><a href="#d0e112">Linux</a></span></dt><dt><span class="section"><a href="#d0e119">MacOS X</a></span></dt></dl></dd><dt><span class="section"><a href="#frrelnotes-getting-started">Getting started / basic features</a></span></dt><dd><dl><dt><span class="section"><a href="#d0e129">Adding a server</a></span></dt><dt><span class="section"><a href="#d0e134">Adding an existing database</a></span></dt><dt><span class="section"><a href="#d0e144">Creating a new database</a></span></dt><dt><span class="section"><a href="#d0e151">Connecting to a registered database</a></span></dt><dt><span class="section"><a href="#d0e156">Browsing metadata</a></span></dt><dt><span class="section"><a href="#d0e163">Editing objects</a></span></dt><dt><span class="section"><a href="#d0e171">Browsing and editing data</a></span></dt><dt><span class="section"><a href="#frmanual-running-sql-statements">Running SQL statements and scripts</a></span></dt><dt><span class="section"><a href="#d0e208">Backup and restore</a></span></dt></dl></dd><dt><span class="section"><a href="#d0e218">Advanced features</a></span></dt><dd><dl><dt><span class="section"><a href="#d0e223">DDL extraction</a></span></dt><dt><span class="section"><a href="#d0e232">Alter View functionality</a></span></dt><dt><span class="section"><a href="#d0e237">Creating a selectable stored procedure for a table</a></span></dt><dt><span class="section"><a href="#d0e242">Connected users</a></span></dt><dt><span class="section"><a href="#d0e247">Event monitoring</a></span></dt><dt><span class="section"><a href="#d0e252">User management</a></span></dt><dt><span class="section"><a href="#d0e260">Grant and revoke privileges</a></span></dt><dt><span class="section"><a href="#d0e265">Server and client version</a></span></dt><dt><span class="section"><a href="#d0e282">Advanced metadata search</a></span></dt><dt><span class="section"><a href="#d0e289">Logging</a></span></dt><dt><span class="section"><a href="#d0e302">Test data generator</a></span></dt></dl></dd><dt><span class="section"><a href="#frrelnotes-configuration">Configuration</a></span></dt><dd><dl><dt><span class="section"><a href="#d0e315">General</a></span></dt><dt><span class="section"><a href="#d0e341">Main Tree View</a></span></dt><dt><span class="section"><a href="#d0e383">SQL Editor</a></span></dt><dt><span class="section"><a href="#d0e478">Data Grid</a></span></dt><dt><span class="section"><a href="#d0e523">Property Pages</a></span></dt><dt><span class="section"><a href="#d0e538">Sql Statement generation</a></span></dt><dt><span class="section"><a href="#d0e613">Fields</a></span></dt><dt><span class="section"><a href="#frmanual-conf-logging">Logging</a></span></dt></dl></dd><dt><span class="section"><a href="#d0e648">Database configuration</a></span></dt><dd><dl><dt><span class="section"><a href="#d0e653">Main Tree View</a></span></dt><dt><span class="section"><a href="#d0e664">Connection</a></span></dt><dt><span class="section"><a href="#frmanual-dbconf-logging">Logging</a></span></dt></dl></dd><dt><span class="section"><a href="#d0e690">Customizing the FlameRobin environment</a></span></dt><dt><span class="section"><a href="#d0e732">Advanced topics</a></span></dt><dd><dl><dt><span class="section"><a href="#d0e737">Encrypted password storage</a></span></dt></dl></dd></dl></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="d0e23"></a>About this manual</h2></div></div></div><p>We try to keep all the features in FlameRobin usable in an intuitive
manner. However, there are things that you still need to know if you want
to grasp the full power of the application, and this manual contains
details about them. In this document, you will find an overview of the
features, a description of all configuration parameters and advanced
installation and customization notes.</p></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="frrelnotes-alphatest"></a>About the ALPHA test program</h2></div></div></div><p>Lots of people have been using FlameRobin in day-to-day work for a
long time now. Yet, we still consider the software in ALPHA state until it
reaches feature-completeness, which will come with release 1.0. FlameRobin
is very near to that state. Meanwhile, we thank you for evaluating and
using this software and encourage you to send comments, bug reports and
feature requests back to us so we can make it a better product.</p></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="frrelnotes-what-fr-is"></a>What FlameRobin is</h2></div></div></div><p>FlameRobin is a GUI administration and data manipulation tool for
Firebird databases. It is designed to be small, simple and cross-platform,
yet offer all the basic features needed to administer Firebird servers and
create/maintain databases. FlameRobin is Open Source software and binaries
are currently available for Windows, several GNU/Linux and BSD flavours
and MacOS X. Ports to other platforms are possible, subject to the
availability of maintainers for those platforms.</p></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="frrelnotes-what-fr-is-not"></a>What FlameRobin is NOT</h2></div></div></div><p>FlameRobin is not a full-featured administration tool with lots of
bells and whistles, as there are plenty available for Firebird from
several different parties. Our first goal with FlameRobin is to provide
people not used to the command line with a GUI tool to get started with
Firebird. Our longer-term goal is to develop a richer tool mainly for the
Linux platform; while there are several rich and mature GUI tools under
Windows, some of them available for free or for a modest price, there
isn't any for Linux. Another goal of the project is for a "lite" edition
of FlameRobin to be bundled with the Firebird server to serve as a
starting kit for new users. This bundle may be distributed by the Firebird
Project itself or by some third party.</p></div><div class="section" lang="en"><div class="title