For known issues please see our bug tracker at:
http://sourceforge.net/tracker/?group_id=124340&atid=699234
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.