What's new in EMS SQL Manager for InterBase and Firebird 6.2.1 Build 57714

Jan 26, 2024
  • SQL is not discarded on exit from Query Designer.
  • Object selection mode added to DB Designer.
  • Connection services are now using the main selected service or utility.
  • Find dialog. ESC closes the popup instead of closing the dialog.
  • Data Import. Encoding is defined automatically now for TXT/CSV files.
  • Parameters are now using TYPE OF COLUMN on creating procedures from table.
  • Authorization dialog added to the Database designer.
  • Fix of importing data with floating points.
  • Collation was modified on editing field size. Fixed now.
  • Fixes of editing TIMETZ values with timezone offset.
  • Fixes for work with databases with NONE encoding.
  • Improvements in displaying dark visual schema.
  • Other minor improvements and fixes.

New in EMS SQL Manager for InterBase and Firebird 6.2.0 Build 57015 (Aug 14, 2023)

  • Processing of new data types added: DECFLOAT, REAL, BINARY, VARBINARY.
  • Improvements in debugging triggers and procedures.
  • The arguments of functions and procedures from the package are added to the autocompletion list.
  • On Update and On Delete actions are now displayed in FK list in table editor.
  • SQL script gets editable in the Duplicate wizard.
  • Zooming works smoother in Database Designer now.
  • The issue of working with BOOLEAN parameters in SQL Script resolved.
  • In some cases SQL Editor tabs cleared after updating host alias. Fixed now.
  • Improved interface and printing options in dark visual theme.

New in EMS SQL Manager for InterBase and Firebird 6.1.2 Build 56391 (Mar 1, 2023)

  • Increased performance of Dependency tree.
  • Better processing of scaling in Database designer.
  • Columns are now displayed for views in Database designer.
  • New Query Data editor is opened empty with Shift+F12 now.
  • The Average Fetch Time value corrected in the Query Statistics.
  • Dark visual theme is not applied on printing dataset now.
  • The error occurred in EXECUTE BLOCK on use of NUMERIC or DECIMAL parameters.
  • Domains are validated on debugging procedures now.
  • The size of large databases is displayed right in the Database Properties now.
  • Scrolling has been improved for specific user cases.
  • Other improvements and bugfixes.

New in EMS SQL Manager for InterBase and Firebird 6.1.1 Build 56187 (Dec 5, 2022)

  • Temporary tables icon added to the DB Explorer.
  • Recent values are now prefilled automatically for parameters in SQL Editor.
  • The error occurred on running EXECUTE BLOCK. Fixed now.
  • Client sorting works smoothly now for all data types.
  • Current generator value can now be changed from object editor.
  • Return values for INSERT ... RETURNING statement are displayed correctly now.
  • Some improvements in working with Embedded server type.
  • Some minor issues with localizations fixed.
  • Other minor improvements and fixes.

New in EMS SQL Manager for InterBase and Firebird 6.1.0 Build 55822 (Jul 14, 2022)

  • INT128 data type support for Firebird 4.
  • Implemented support for query interrupting in Query editor.
  • Support for Windows 11 ARM.
  • Host aliases added.
  • Added the ability to specify an encryption password on connecting to Interbase databases.
  • Added the ability to securely connect to the database with the isc_dpb_no_db_triggers option.
  • Added an option that disables automatic host availability check.
  • When renaming a table field, it was moved to the end of the field list. Fixed.
  • The value of the auto-increment field generator is now shown in the table editor in the field list.
  • Support for new generator options in Firebird 3 and higher.
  • Fixes in Event Monitor to get all notifications.
  • Corrections and improvements in the dark visual theme.
  • You can manually add transaction options in the database settings now.
  • Other changes and improvements.

New in EMS SQL Manager for InterBase and Firebird 6.0.2 Build 55003 (Sep 29, 2021)

  • Improved processing of Unicode data.
  • System-generated indices are no longer generated in Extract database wizard.
  • Better processing of embedded servers, including old versions.
  • Default value can be disabled in domain editor now.
  • Parsing of procedures containing cursor has been improved.
  • Other minor fixes.

New in EMS SQL Manager for InterBase and Firebird 6.0.0 Build 54552 (Feb 20, 2021)

  • Support of dark visual scheme added.
  • The new look with updated icons.
  • Editor tabs can be now highlighted with the specified database color.
  • Improved support of high-DPI monitors and large-scale fonts.
  • Support of Unicode for object names added.
  • Support for custom server aliases implemented.
  • Improved search when using regular expressions.
  • JSON tab added for viewing data.
  • SQL parser improved for better performance.
  • Timezone support implemented.
  • Updated SSH library with ECDSA and Ed25519 support.
  • Many other improvements and fixes.

New in EMS SQL Manager for InterBase and Firebird 5.5.3 Build 52046 (Dec 4, 2018)

  • Support of Unicode is added to data filters now.
  • The error of processing arguments for some types of UDFs fixed.
  • The Browse button for selecting the local database was disabled in some cases. Fixed now.
  • Some domain-based variables were processed as Cursor in the debugger. Fixed now.
  • Query builder. Improved resolving of table aliases.
  • Sometimes query results were read-only. Fixed now.
  • Successfully executed queries are now correctly saved in the log.
  • A few fixes in grid levels.
  • DB Explorer tree is refreshed OK with Sort by aliases option enabled.
  • Unique option can be selected for expression index now.
  • We added the possibility to clear parameters history for procedures.
  • Data is sorted correctly locally in asynchronous mode now.
  • Many other bug-fixes and improvements.

New in EMS SQL Manager for InterBase and Firebird 5.5.2 Build 51085 (Apr 25, 2018)

  • Password field for encrypted databases has been added.
  • SQL Script performance has been improved.
  • Several triggers can be selected for activation and de-activation now
  • Minor issues fixed in the debugger
  • The error on filtering data on the client side has been fixed
  • Functions with declared functions are supported now.
  • Views were not displayed correctly in VDBDFixed now.
  • ARRAY data type is processed correctly now.
  • Field types based on table fields are displayed correctly now
  • Variables in DB triggers were not refreshed correctlyFixed now
  • Grant AllRevoke All operations for table fields work correctly now
  • Search in the DB tree terminated on opening or closing the folderFixed now.
  • Many other fixes and improvements

New in EMS SQL Manager for InterBase and Firebird 5.5.1 Build 50223 (Sep 11, 2017)

  • The protocol for Firebird 3.0 was detected incorrectly. Fixed now.
  • The length for text fields was calculated incorrectly in Export Data wizard. Fixed now.
  • Varaibles were not displayed correctly in object editors. Fixed now.
  • Some fixes in UDF editor.
  • The errors of executing script with DECLARE FILTER statement fixed.
  • Other minor fixes.

New in EMS SQL Manager for InterBase and Firebird 5.5.0 Build 49966 (Aug 4, 2017)

  • Added support of packages.
  • Performance of SQL-parser in SQL Script/Editor has ben significantly improved.
  • Added support of 'Restart With' clause for 'Identity' table fields.
  • Added the possibility to browse and reuse recently used parameters in SQL Editor, Procedure Editor and Debugger.
  • The issues of executing "unknown" statements in SQL Script have been fixed.
  • The errors of converting specific data types in the Debugger have been fixed.
  • Data was displayed incorrectly when non-Unicode client charset was set and it did not correspond to the current system locale. Fixed now.
  • When separate connections were used in SQL Editor, transactions were not ended correctly sometimes. Fixed now.
  • Unicode characters were displayed incorrectly in Duplicate wizard. Fixed now.
  • If the script contained 'SET TERM' statements the error occurred on executing it from file. Fixed now.
  • Many other fixes and improvements.

New in EMS SQL Manager for InterBase and Firebird 5.4.4 Build 49657 (Jul 22, 2017)

  • Fix of errors and hangings in SQL Editor.
  • Timestamp fields were not quoted on exporting as SQL script. Fixed now.
  • Boolean values are exported as truefalse now.
  • The ‘Unexpected Output buffer value’ error rarely occurred on connecting to Firebird server. Fixed now.
  • Procedures were not refreshed correctly sometimes. Fixed now.
  • Default values for NUMERIC type are now displayed as a number not a string.
  • The 'Cannot convert value '' to the specified type' error occurred on creating the DATE type parameter in procedures. Fixed now.
  • Many other improvements and bugfixes.

New in EMS SQL Manager for InterBase and Firebird 5.4.3 Build 49283 (Apr 18, 2017)

  • Support of exporting selected records has been added to 'Export as SQL Script' wizard.
  • Support of IDENTITY fields in Firebird 3 has been implemented.
  • Now BLOB text data is opened on the Text tab by default.
  • Visual Database Designer. Changes in tables are immediately applied to the objects tree now.
  • The default encoding is applied correctly on saving SQL Editor content to file.
  • Unicode symbols are exported correctly in 'Export as SQL Script' wizard now.
  • Multiple operators are copied correctly now in the Compile window.
  • The queries containing CROSS JOIN operator where not executed correctly. Fixed now.
  • Parameters in functions are edited correctly now.
  • GRANT ALL works correctly now in Grant Manager.
  • SELECT from procedures couldn’t be visualized in Query Builder. Fixed now.
  • Use of local utilities in services works correctly now.
  • Other fixes and improvements.

New in EMS SQL Manager for InterBase and Firebird 5.4.2 Build 48438 (Dec 6, 2016)

  • Fixes for script errors, views, SUID procedures and more...

New in EMS SQL Manager for InterBase and Firebird 5.3.0 Build 46301 (Oct 22, 2015)

  • Added support of InterBase XE3, InterBase XE7.
  • Added support of the COALESCE function in Visual Query Builder.
  • Added support of the 'WHERE CURRENT OF (cursor)' clause in Debugger.
  • Added support of the 'USING [DESC] INDEX' clause for Foreign Keys.
  • Implemented support of Unicode for XML format in Export Data function.
  • Displaying of the database physical size is implemented in the Database Properties dialog.
  • Visual Database Designer. Highlighting of Foreign Keys fields was implemented.
  • The 'Quick Save\Quick Load' feature was enhanced. Some bugs were fixed.
  • The connection restoring ability was enhanced.
  • Fixed many bugs in Debugger.
  • Sometimes subobjects were displayed incorrectly in Object Inspector. Fixed now.
  • Added the possibility to load the latest saved diagram when opening Visual Database Designer.
  • Added the possibility to use Code Completion feature with the 'OLD/NEW' keywords in Triggers.
  • Now it is possible to switch off the Precompiler for views.
  • Lots of fixes in displaying Dates/Milliseconds at the Data tab.
  • Fixed the memory leak while exporting to CSV.
  • Localization fixes.
  • Lots of other improvements and bug-fixes.

New in EMS SQL Manager for InterBase and Firebird 5.2.0.1 (Jun 12, 2014)

  • Windows 7 support
  • Preliminary support of InterBase 2009
  • Database Properties: added support of Embedded User Authentication (EUA) for InterBase 7.5 and higher
  • DB Explorer:
  • Added the Embedded User object for InterBase 7.5 and higher. Creating, editing, duplicating, activating/deactivating and deleting operations are supported
  • It is now possible to activate/deactivate the EUA mode for InterBase 7.5 and higher
  • For Firebird 2.5 it is now possible to create a view from a stored procedure
  • Connection to a database with the Local protocol used was not possible on InterBase Desktop Edition servers. Fixed now
  • Connection to a host with the NTLM authentication caused an error. Fixed now
  • It was impossible to connect to the database the path to which contained Unicode characters. Fixed now
  • Connection to an InterBase database with a client library of version lower than 6.0 caused an error. Fixed now
  • Upon connection to the first newly registered host the list of users was not refreshed. Fixed now
  • When connecting to a host via SSH tunneling with a passphrase request, it was impossible to input the passphrase. Fixed now
  • User Editor / User Manager: for InterBase 7.5 and higher added an opportunity to work with Embedded Users
  • Role Editor: for InterBase 7.5 and higher added an opportunity to add Embedded Users to roles
  • Grant Manager / Permissions frame in object editors: for InterBase 7.5 and higher added the possibility to manage privileges on objects for Embedded Users
  • Extract Database:
  • for InterBase 7.5 and higher added extraction of Embedded Users
  • data of NUMERIC type was extracted with incorrect delimiter from Firebird 2.1 databases. Fixed now
  • object names were sorted in the descending order upon extraction. Fixed now
  • Table Editor:
  • changed the method of accumulating script for compiling changes made in the editor
  • added an optional possibility to open a separate editor by double-clicking a trigger displayed under the Triggers tab. Changes made in the separate editor will not be added to the result script of Table Editor. The corresponding option is added to the Environment Options dialog
  • field descriptions were not saved completely. Fixed now
  • Procedure/Trigger/DB Trigger Editor:
  • Added the possibility to use Explicit Cursors for Firebird 2.x
  • Added the auto-filling cursors ability
  • In Procedure Editor it is now possible to create a view from the stored procedure being edited
  • Using the WEEK keyword in the script resulted in a precompiler error. Fixed now
  • On attempt to compile a procedure containing the CREATE OR ALTER PROCEDURE statements the error occurred. Fixed now
  • Modal object editor windows are now resizable for the more convenient work
  • View Editor:for Firebird 2.1 and higher it is now possible to use Common Table Expressions (CTE)
  • Added an optional possibility to open a separate editor by double-clicking a trigger displayed under the Triggers tab in the Table Editor and the Triggers tab in the View Editor. Changes made in the separate editor will not be added to the result script of the View Editor.
  • SQL Editor:
  • Added the auto-filling cursors ability for the Execute Block statement
  • Added a scrollbar under the Plan tab
  • Some erroneous queries were executed without any error messages. Fixed now
  • Inputted parameters were not saved upon execution of parameterized queries. Fixed now
  • The Result tab was not displayed in the 'Asynchronous query execution' mode. Fixed now
  • In some queries the ORDER BY clause was truncated. Fixed now
  • Keyboard Templates: added new keyboard templates
  • Query Builder: after loading a diagram from file the query was corrupted. Fixed now
  • Debugger:
  • debugging an object containing EXECUTE STATEMENT caused an error. Fixed now
  • Implemented support of procedures with Explicit Cursors
  • Export as SQL Script: export of Unicode data was performed incorrectly. Fixed now
  • Visual Database Designer: Unicode text was displayed incorrectly in comments. Fixed now
  • Create Updatable View:
  • incorrect script was generated for the Before Update trigger. Fixed now
  • The Compile window did not appear for an invalid script. Fixed now
  • SQL Monitor: erroneous statements from SQL Script were now displayed by SQL Monitor. Fixed now
  • Dependency Tree:
  • Added an ability to place the selected object to the display area automatically when the tree of dependencies is large
  • Added an ability to move the tree within the display area holding the left mouse button
  • Changed the drawing of the selected object and recursive objects for better distinction
  • Added diagram layout options: to show all objects, only objects depending on the Root object, or only objects the Root object depends on
  • Added an ability to show/hide domains in the dependency tree
  • Environment Options:
  • added an option allowing one to specify the database that will be selected for a newly opened editor or a newly started service: the one selected in DB Explorer or in the currently focused editor
  • added an option allowing one to specify the way the editors layout is saved: for each particular object or for all objects of one type
  • Visual Options:
  • added an ability to set Slants Kind in the Page controls options
  • user-defined visual scheme was only applied upon clicking 'Apply' twice. Fixed now

New in EMS SQL Manager for InterBase and Firebird 5.1.0.5 (May 28, 2009)

  • Preliminary support of Firebird version 2.5.
  • Register Host wizard:
  • The work with embedded servers is improved. Now you don’t need to copy files to the IB/FB Manager root folder, the server can be registered from any folder to which the server archive was unzipped.
  • Improved the Autodetect client library/security database path function.
  • Register Database wizard:
  • The options are added which allow set up Data Grid modes for each database.
  • The options concerned with transaction parameters are added to the Database Registration dialog which allows you to set them up for each database.
  • The ‘Sort by primary key’ option is added, which allows sort data by the primary key on opening the Data Grid.
  • Database Properties:
  • The ability to change parameters of the database which is not connected at the moment is added.
  • Now you are able to set database buffer parameters.
  • Changing of the database dialect was applied only after the program restart. Fixed now.
  • DB Explorer:
  • Context menu items concerned with launching additional server/database/object tools are placed into the Tasks submenu to reduce the context menu size.
  • Now you can call the debugger for procedures, triggers, DB triggers, as well as for Favorite Queries that contain scripts implicating debugging.
  • The button for switching the search mode is added to the toolbar.
  • When renaming a host which had several databases registered on and after restarting the program, the database structure displayed in the DB Explorer used to be incorrect. Fixed now.
  • Table Editor:
  • New Table Editor form.
  • The ability to create external tables is added.
  • The ability to create global external tables is added.
  • The file name of the external tables used not to be displayed in the DDL. Fixed now.
  • Procedure/Trigger/DB Trigger Editor:
  • The autocompletion function is implemented for parameters and variables.
  • During the compilation process the precision of all parameters and variables of the NUMERIC(x,y) and DECIMAL(x,y) types used to be reduced to the precision of the first parameter. Fixed now.
  • During the compilation process the NULL default value was lost. Fixed now.
  • Using the WEEK keyword in the script resulted in a precompiler error. Fixed now.
  • On attempt to compile a procedure containing the CREATE OR ALTER PROCEDURE statements the error occurred. Fixed now.
  • Modal Object Editor:
  • The modal editor windows are made resizable for the more convenient work.
  • SQL Editor:
  • The ability to call debugger for scripts that implicate debugging is implemented.
  • The autocompletion function is implemented for parameters and variables of the scripts, procedures, triggers, DB triggers and the EXECUTE BLOCK constructions.
  • Usage of the FIRST keyword in a query resulted in an error. Fixed now.
  • Queries with string comments were not executed. Fixed now.
  • Data Grid:
  • The method of work in the asynchronous mode is changed – the usage of a separate connection for each Data Grid allows to perform simultaneous fetching without losing the ability to use other functions of the program.
  • The synchronous mode now allows using the shared connection for all Data Grids, which is essential for the servers with the limited number of allowed connections and for the work with global external tables that remain actual within the connection context.
  • Sorting by primary key is performed optionally now.
  • SQL Monitor:
  • Refreshing a database with the opened SQL Monitor resulted in the hanging of the program. Fixed now.
  • SQL Script:
  • The ability to execute scripts/procedures/DB triggers without the SET TERM construction is implemented.
  • The errors occurred during the script execution are fixed.
  • In some rare cases the script execution errors were not displayed. Fixed now.
  • Table Altering Monitor is implemented within a separate thread, so that you can take advantages of other program functionalities when working with that tool.
  • DB Extract:
  • DB journals can be extracted now.
  • Conversion of the script to the selected charset occurs now during the extraction and not at the moment of saving to a file which reduces the script generation time.
  • Triggers used to be omitted when extracting the full database. Fixed now.
  • When extracting triggers, some of them were processed with empty bodies. Fixed now.
  • Export as SQL Script:
  • Conversion of the script to the selected charset occurs now during the extraction and not at the moment of saving to a file which reduces the script generation time.
  • Debugger:
  • The ability to debug Favorite Queries that contain scripts implicating debugging is implemented.
  • The Watches tab is added which allows display parameter and variable values from different contexts in one window.
  • The ability to delete/activate/deactivate all breakpoints at once is implemented.
  • Options:
  • The options concerned with database settings are duplicated/moved to the Database Registration Info form, which allows setting them up for each database separately.
  • The ability to apply default settings (for all or just a separate category of options) is implemented for all option dialogs.
  • The Object Templates form is revised. New templates are added.
  • The ability to save object templates is implemented.
  • The Save Options wizard saves data in a separate thread now, so that you can take advantages of other program functionalities when working with that tool (especially useful when many databases are registered).
  • Visual Database Designer:
  • Virtual relations can be renamed now.
  • When opening a saved diagram containing virtual relations, those relations used to change their location comparing to the location at the moment of saving. Fixed now.

New in EMS SQL Manager for InterBase and Firebird 4.3 (Jun 20, 2006)

  • This is a bugfix release for the current production release version.

New in EMS SQL Manager for InterBase and Firebird 4.2 (Apr 25, 2006)

  • German localization added.
  • SQL Editor. Key Mapping is implemented to set the shortcuts for various commands/operations according to your needs.
  • Query Builder. Query execution plan is now displayed as a graphical diagram.
  • Dependency Tree. The diagram can now be printed.
  • Ability to call Database Registration Wizard from SQL Script for the databases created is implemented.
  • Other improvements and bug fixes.