For known issues please see our bug tracker at:
http://sourceforge.net/tracker/?group_id=124340&atid=699234
Changes in FlameRobin 0.7.6 ALPHA
New features
- Logging changes to database table (so far only logging to textual files was available)
- Finally, FlameRobin is 100% compatible with Firebird 2.0
Enhancements and Bug fixes
- Improved parsing of committed statements
- Fixed bug #1591149 when reserved XML characters were used in database properties
- Fixed bug #1582935 with drag and drop query building
- Setting to clear log when executing is now respected
- Added META tag to exported HTML data: set to UTF-8 encoding
- Fixed invalid columns when fetching data fails
- Autocompletion now works properly with quoted identifiers
- Fixed crash when loading of property page fails
- Fixed crash when automatic DDL commit was active
- Fixed ALTER VIEW script - triggers are now included
- Fixed DDL extraction for UNIQUE INDEX
- Fixed DDL extraction for NUMERIC(x, 0) types
- Fixed problem with selection becoming invisible on Linux/Gtk
- Main tree view now behaves consistently on both double-click and Enter pressed
- Fixed minor UI glitches
Changes in FlameRobin 0.7.5 ALPHA
New features
- System tables now are available in main tree view
- Autocompletion of column/parameter names and old/new aliases in triggers
- Compatibility with Firebird 2.0
Enhancements and Bug fixes
- SQL Editor: Use row:col instead of col:row in statusbar
- SQL Editor: Autocompletion now works for case-sensitive object names
- SQL Editor: Autocompletion now works for names containing $ character
- Data grid: "Fetch all records" and "Cancel fetching all records" commands
- Data grid: "Copy records as Update" command
- SQL script execution now always stops on error
- Confirm dropping of items from main tree
- Fixed bugs related to character set conversions
- Fixed DDL extraction for various object types
Changes in FlameRobin 0.7.2 ALPHA
Enhancements and Bug fixes
- Fixed crash when opening role's property page with Firebird 1.x
- Fixed DDL extraction for unique constraints
- Fixed updating of privileges page for procedures
- Removed dependency on Firebird 2.0 for Gtk2 package
Changes in FlameRobin 0.7.1 ALPHA
Enhancements and Bug fixes
- Firebird client library version is removed from About box
- This version works with Firebird 1.0
Changes in FlameRobin 0.7.0 ALPHA
New features
- User management
- View, grant and revoke privileges on database objects
- Encrypted password storage
- Search SQL statement history and remove chosen entries
- Property page for databases
- License changed from IDPL to MIT/Expat
- Advanced metadata search (experimental - please provide feedback, so we can improve it)
Enhancements and Bug fixes
- Consistent property pages navigation
- UTF-8 charset changed to proper UTF8
- Identify user-named system-generated indices (needed for FB > 1.0)
- Fixed DDL extraction for various objects
- Two-step loading of property pages (more user friendly)
- Option to show objects DDL in SQL editor
- SQL Editor: ignore function keys when Ctrl or Alt are down
- Data grid: right-align nulls for numeric columns
- Data grid: display of milliseconds for time values
- Data grid: improved display of Unicode characters
- Various changes of user preferences are now instantly applied
- GTK: changes of tree control to look like native one
- GTK: Use of standard button IDs adds icons and localized captions
- Statement parser: identifiers of one char are no longer handled as empty
- Property pages now display much faster
- Autogenerated INSERT statements now show default values where available
- Firebird client library version is shown in About box
- various UI fixes and enhancements
Changes in FlameRobin 0.6.0 ALPHA
New features
- DDL extraction for all object types
- Rebuild View option (drop and recreate dependent objects)
- Option to drop database
Enhancements and Bug fixes
- TCP port setting is not longer ignored when creating, backing up and restoring databases
- New dialog for index creation.
- Field properties dialog can now be closed when no changes are made.
- Main tree control now behaves natively on all platforms.
- Progress dialog when connecting has ability to cancel
- Windows: FlameRobin doesn't destroy Clipboard contents when exiting
- Gtk2: Reduced font size for property pages.
- Gtk2: allow user to enter filename in dialogs.
- Other minor UI improvements.
- Faster disconnecting.
- Faster startup of SQL editor, statement history stored in separate files.
- Warn when copying data from the grid and not all rows have been fetched.
- If error happens while executing selection, the executed statement is selected in SQL editor.
- Fixed problem with context menu and large selection in SQL Editor.
- Fixed hiding of SQL editor behind other windows.
- Data grid is now scrolled by rows
- Triggers can be added/dropped from table's "Triggers" page.
- Take character set and collation into account when adding new columns.
- Configurable columns (default value, description) on table's property page.
- All UPDATE statements were treated as DDL. Fixed.
- Fixed bugs in statement parser.
- Preserve character sets when altering procedures.
- Added missing whitespace between AS and procedure source.
- Privileges are restored after ALTER VIEW.
- Property pages are now updated after ALTER INDEX and SET STATISTICS
- Custom charsets are now really used when connecting to database.
- Logging can now log SET TERM statements if desired.
- Logging now detects if target directory doesn't exist.
- Updated documentation about building FlameRobin.
Changes in FlameRobin 0.5.0 ALPHA
New features
- Event monitor: a dialog to register for and monitor posted events
- Support for quoted identifiers (case sensitive, etc.)
- Quick metadata search from the main screen
- Ability to retrive server version
Enhancements and Bug fixes
- Parsing of executed statements rewritten to work properly
- "Alter" menu item for procedures, triggers and views
- Allow user to enter backup filename with GTK2
- Fixed message dialogs which didn't have any buttons on GTK1
- Improved dependency detection (objects referenced in CHECK constraints)
- Support for 64-bit platforms
- SQL editor is no longer created beneath other windows
- Option to change tab size in SQL editor
- Option to show long line marker in SQL editor
- Many minor fixes and improvements for SQL editor
- Fixed problem with visible caret when SQL editor doesn't have focus
- Improved running of large SQL scripts
- Fixed problem with auto-completion on GTK2
- Option to limit size of single item in statement history
- Fixed drag and drop query building with multiple foreign keys
- Fixed disconnect problems on some Linux distributions
- Registered server and databases are saved instantly (for multiple instances of FlameRobin)
- Display name was used instead of hostname for backup and restore
- Fixed backup and restore problems on PPC
- Backup and restore dialogs show file selector with path of current file name
- Backup and restore settings are remembered on database basis
- FlameRobin is buildable with Borland's compiler again
- Improved overall speed in some areas
- Fixed reported character field lengths for multibyte character sets
- Fixed problems with datatypes when there aren't any user-defined domains in database
- Links included in saved .html Property pages
- Changed the way strings are translated in Unicode versions
- Cancel button isn't ignored anymore when adding unique constraints
- Cancel button isn't ignored anymore when reordering fields
- Improved Field editor
- Allow usage of various formats for multiple log files
Changes in FlameRobin 0.4.0 ALPHA
New features
- History of SQL statements, presistent even after closing program
- Activate/deactivate option for triggers
- "Drop multiple columns" option for tables
- Execute option for procedures
- Preferences can be set on database basis (ex. logging)
- Option to restore backup into new database
- Support for SET AUTODDL isql feature and option to automatically commit DDL statements
- Support for RECREATE and CREATE OR ALTER statements
- FreeBSD port
Enhancements and Bug fixes
- Fixed bug when password is supplied upon connecting
- Fixed parsing of committed statements when statement starts with a comment
- Main menu system reorganized
- Configuration files reorganized: user configuration files stored in user's directories
- Option to hide the status bar
- Option to hide databases that are not connected
- Fixed background colors of read-only fields in various dialogs
- Fixed "no database assigned" error for new databases
- Made sure the statement with error is visible in large scripts
- Changed the execute key to F4, as F9 has a special meaning on some platforms
- Long text now wraps on Dependencies page, making to easier to read
- Fixed scrollbar bugs of data grid with Linux port
- Mousewheel now works on Linux
- IBPP library sources added to the project
- Compare database's and connection charset and warn user if they differ
- Bigint datatype added to field properties dialog
- Option to disable autocompletion inside quoted text
- Fixed bug that sql editor dialog can have an empty title
- Improved handling of fatal exceptions
Changes in FlameRobin 0.3.0 ALPHA
New features
- Support for computed columns (shown in tree, removed from insert statements)
- Calltips for UDFs
- Properties page for UDFs
- Option "create new trigger" for tables and views
- Support for table indices - display, add, drop, recompute stats., edit descriptions
- Property page for view's triggers
- Select object's name in SQL editor and get its properties page
- Context menu for properties windows with options to print and save contents
- Implemented "open in new window" context menu option for properties page links
- Added main menu for main application window
- Added "diplay name" to servers and databases
- "Connect as" option for databases: ability to connect as different user/role without need to register new database
Enhancements and Bug fixes
- ALTER TABLE x ALTER COLUMN y updates the tree/properties page
- Improved handling when adding NOT NULL columns
- Fixed bug when SP and triggers contained ampersand (&) in source (FR would hang)
- Size and position of minimized windows is not stored anymore
- Pressing function keys and clicking buttons in SQL editor now does the same
- Prompt to overwrite files when saving in SQL editor
- Faster startup upon connection since domains are loaded on-demand
- Dropping tables and views now properly removes triggers from tree
- Fixed parsing of CREATE,ALTER,DROP trigger statements (tables/views get notified)
- Saving data to html file now uses default .html extension if user does not supply it
- Fixed and improved dependencies detection for database objects
- Fixed logging to file: newlines are added when headers are off
- Registration of Firebird embedded server is now possible from application
- Firebird 1.5 charsets made available, charset box is user editable to support future charsets
- Current tree item's database printed in status bar instead of tooltip
- Improved connecting speed by postponing loading of autogenerated domain info
Changes in FlameRobin 0.2.5 ALPHA
New features
- New Preferences dialog.
- Option to show/hide datatype and/or domain name in tree.
- Ability to keep working after fatal errors.
- Ability to prepare a statement (and show its PLAN) without actually executing it.
- New context menu for the SQL Editor and new "Execute selected" command.
- Ability to set a custom font for the SQL Editor.
- Ability to set a custom font for the data grid header and cells.
- Option to maximize the data grid when a certain number of rows has been fetched.
- SQL Editor: auto-completion can be disabled and invoked manually.
- Calltips for stored procedures in the SQL Editor.
- Basic drag&drop stuff (drag columns/tables from the tree to the SQL Editor).
- SQL Editor: new Option to clear old messages when executing new statements.
- You can set up logging of DDL (and optionally DML) statements to user defined log file(s).
- Configurable double-click action for tables, views and SPs in main tree.
- Option to prompt on exit.
- Option to alphabetically sort server and database entries in tree.
- Option to center dialogs on the screen.
- SQL Editor: new Search & replace tool (with support for regular expressions).
- Ability to add a new column to a table directly from the tree.
- Option to disallow showing table/view columns and stored procedure parameters as tree nodes.
- Option to make it so that a double click on a tree item shows the properties dialog instead of expanding the subtree.
- Added context menu for table columns in tree.
Enhancements and Bug fixes
- Data grid: tabs used as separators instead of spaces when copying data to the clipboard.
- Added server name (beside user@host) to the SQL Editor status bar.
- "Insert into" command now puts VALUES clause on a new line.
- Data grid: fixed display issue for non-null blobs.
- Better automatic name suggestion for constraints (avoids duplicate names).
- Fixed bug that caused FR to consume 100% CPU while doing nothing.
- Databases couldn't be created if Page size was left to the default value.
- SQL Editor: FR did hang when "set term" was issued without terminator.
- SQL Editor: fixed bug when statement consisting solely of comments is executed.
- SQL Editor: comments before SET statements were not handled correctly.
- Data grid: platform-standard line breaks are now used when copying data to the clipboard.
- Undo/redo/cut/copy/paste now work properly in the SQL Editor.
- The Data grid is now much more responsive even with a lot of NULLs in it.
- SQl Editor: added NULL to autocomplete list (solves known NULLIF problem).
- Fixed constant 1-pixel frame growth for Windows 98.
- Made database connections actually respect the charset.
- Maintain separate size for database creation/registration info dialogs.
- ALTER PROCEDURE now correctly reloads procedure parameters.
- Changing column datatype for field editor now works.
- Tree nodes can now be activated with double-click/Enter key on Linux too.
- Enabled clicking inside selection in the SQL Editor.
- Copy/paste of descriptions now works on Linux too.
- Fixed crash when changing field type from one to another user defined domain.
- Fixed known issue: if the connection credentials (username and password) of a registered database were modified, the new credentials were not used until FlameRobin was restarted.
Changes in FlameRobin 0.2.0 ALPHA
New features
- Brand new Backup/Restore dialogs that work in background, let you suppress the output messages and store their settings among invocations. Plus, the output messages can be copied to the clipboard.
- Many dialogs have been redesigned and now feature a cleaner GUI.
- "Show value" and "Show all values" context menu commands implemented for generators.
- Exceptions are now shown in the tree view and have Create/Drop menu commands and a property page.
- Property pages for triggers, table constraints, dependencies (all objects), generators were added. Plus, a special empty property page now appears for not yet supported object types, instead of an error message.
- Ability to view/add/drop table constraints.
- Reconnect menu command for databases will physically disconnect and reconnect a database in one shot.
- "Create new" and "Drop" commands added for external functions.
- New MacOS X port.
Enhancements and Bug fixes
- When new objects are added to the database through a "CREATE" DDL statement, they are inserted in the right place in the tree view, instead of at the end of the lists.
- The tree view shows primary key table fields with a different icon.
- It is now possible to edit triggers.
- User-defined domain names appear together with column datatypes in the property pages.
- Improved startup speed.
- config.ini entry "FrameStorage=1" now works for all frames and dialogs (it only stores size - not position - for dialogs).
- New multi-format program icon that looks OK at all sizes (16x16, 32x32, 48x48 and 128x128).
- In the SQL Window you can press Ctrl + "+" and Ctrl + "-" to increase and decrease the font size. The setting is remembered across sessions of FlameRobin.
- In the Server Registration dialog the controls are now read-only if any database is connected.
- New program icon.
- Assorted bug fixes.