What's new in FlameRobin 0.9.3
May 19, 2010
- Newly reserved words of 2.x FB versions should be highlighted now and quoted if used as column names and the like, please report if any are missing.
- New menu command in SQL editor frame to set transaction lock resolution (wait / no wait).
- Modifying column properties should no longer modify the name unless it was explicitly changed.
- "SELECT FROM ..." for tables and views and "EXECUTE ..." for procedures should now create statements with the keywords upper- or lower-cased as specified in the preferences, and which should be line-wrapped to a width of (currently) 100 chars. They should also use the correct platform-native line ending now. This is a first step only, if this works as intended and there are no adverse side effects then the new StatementBuilder class should be used throughout FR to create user-visible SQL statements. Testing of this is definitely needed, feedback especially welcome. There is already a preference setting "sqlEditorMaxLineLength" that isn't surfaced yet in the preferences dialog, maybe the line length should simply be taken from the SQL Editor line marker column? And should it be possible to disable the line-wrapping completely?
New in FlameRobin 0.9.2 (Apr 25, 2009)
- New features
- Allowed deleting from system tables (ex. to stop queries via MON$STATEMENTS)
- Added support for trusted authentication
- Databases can now be recreated from existing registration info
- Transaction isolation level can now be selected in SQL editor
- Win64 port
- Enhancements and Bug fixes
- Fixed problems with mangled UTF8 identifiers
- Improved autoincrement triggers
- Drop FK only once for self-referencing tables in Rebuild script
- Improved management of passwords in connection dialogs
- Case insensitive DoMaIn keyword detection
- Fixed reported length of char fields in DDL extraction of system tables
- Fixed minor DDL extraction problem with BIGINT and scale
- Search words are now highlighted in advanced metadata search results
- DataGrid: sum of values of selected cells in the grid is shown in status bar
- Data grid cell editor now has a popup menu of a standard edit control
- Data of CHAR type using multibyte character set has correct padding now
- Database file size is now reported correctly for databases over 2GB
- Opening pages in tabs can now be controlled with Shift/Control keys
- Information on database property page is reloaded without reconnecting
- Fixed focus problem with property pages
- Fixed broken descriptions of system table columns in property pages
- Optionally display sources of all triggers on table property page
- Controls are now focused before their popup menus are shown
- Improved usability of menus and commands via keyboard
- SQL Editor: Improved detection of field sizes in resulting dataset
- Fixed statement parsing when SUBSTRING function is present
- Fixed column autocompletion for JOINed tables
- Fixed code completion when tables are listed in SQL89 order
- Fixed crash when opening query window and pressing F5 or F8 at once
- Improved the way views are switched in SQL editor
- Fixed completion under Mac OS X
- Other minor improvements and fixes to SQL editor
- Statement execution time is now displayed with milliseconds precision
- Minimum required version of wxWidgets is now 2.8.
New in FlameRobin 0.9.2 Alpha (Apr 13, 2009)
- New features:
- Allowed deleting from system tables (ex. to stop queries via MON$STATEMENTS)
- Added support for trusted authentication
- Databases can now be recreated from existing registration info
- Transaction isolation level can now be selected in SQL editor
- Win64 port
- Enhancements and Bug fixes:
- Fixed problems with mangled UTF8 identifiers
- Improved autoincrement triggers
- Drop FK only once for self-referencing tables in Rebuild script
- Improved management of passwords in connection dialogs
- Case insensitive DoMaIn keyword detection
- Fixed reported length of char fields in DDL extraction of system tables
- Fixed minor DDL extraction problem with BIGINT and scale
- Search words are now highlighted in advanced metadata search results
- DataGrid: sum of values of selected cells in the grid is shown in status bar
- Data grid cell editor now has a popup menu of a standard edit control
- Data of CHAR type using multibyte character set has correct padding now
- Database file size is now reported correctly for databases over 2GB
- Opening pages in tabs can now be controlled with Shift/Control keys
- Information on database property page is reloaded without reconnecting
- Fixed focus problem with property pages
- Fixed broken descriptions of system table columns in property pages
- Optionally display sources of all triggers on table property page
- Controls are now focused before their popup menus are shown
- Improved usability of menus and commands via keyboard
- SQL Editor: Improved detection of field sizes in resulting dataset
- Fixed statement parsing when SUBSTRING function is present
- Fixed column autocompletion for JOINed tables
- Fixed code completion when tables are listed in SQL89 order
- Fixed crash when opening query window and pressing F5 or F8 at once
- Improved the way views are switched in SQL editor
- Fixed completion under Mac OS X
- Other minor improvements and fixes to SQL editor
- Statement execution time is now displayed with milliseconds precision
- Minimum required version of wxWidgets is now 2.8.
New in FlameRobin 0.8.6 (May 16, 2008)
- DataGrid: BLOB data is now (optionally) shown in cells. Read-only for now.
- DataGrid: A basic ORDER BY clause building when column header is double-clicked
- Support for LIST function in Firebird 2.1
- Support for MON tables in Firebird 2.1 (Read-only for now.)
- DataGrid: FR no longer crashes when transaction has ended (commit/rollback) and grid edit control is active
- DataGrid: Complete string is now shown for editing and copying multiline text
- DataGrid: Copy command now copies a single cell if nothing is selected
- DataGrid: Fixed mixup between BLOB ID and data it contains
- DataGrid: Fixed bug when editing or deleting in grid causes exceptions.
- DataGrid: Successfully deleted rows are deselected, so user can easily see what is done.
- DDL extraction for GRANTs now only quotes names when needed
- DDL extraction for defaults does not use double quotes anymore.
- Database property page now shows minor ODS version when it is not zero
- Hovering over icons in privileges window, now really shows the grantor
- Improved parsing of SELECT statements
- Support for INSERT..RETURNING and EXECUTE STATEMENT that return a single record
- Fixed messagebox flood when Execute Procedure called and it doesn't return anything
- Print preview and SaveToHtmlFile works again for manual and changelog
- Extracting invalid DDL (missing domain data in system tables) does not crash FR anymore
- Silent installation (on Windows) does not show changelog window anymore
- Autogenerated domains (system domains) do not show up in the tree anymore
- Added ALTER DOMAIN action for domains
- Tree now shows NOT NULL for columns that inherit NOT NULL from domain
- Fixed parsing bug when non-reserved keyword is used as identifier
- Fixed autocomplete for selectable procedure alias when procedure call contains parameters (in PSQL)