Online Documentation for SQL Manager for InterBase/Firebird

Version history

 

Full version history is available at http://www.sqlmanager.net/products/ibfb/manager/news

 

Version 6.2.1

1. SQL is not discarded on exit from Query Designer.

2. Object selection mode added to DB Designer.

3. Connection services are now using the main selected service or utility.

4. Find dialog. ESC closes the popup instead of closing the dialog.

5. Data Import. Encoding is defined automatically now for TXT/CSV files.

6. Parameters are now using TYPE OF COLUMN on creating procedures from table.

7. Authorization dialog added to the Database designer.

8. Fix of importing data with floating points.

9. Collation was modified on editing field size. Fixed now.

10. Fixes of editing TIMETZ values with timezone offset.

11. Fixes for work with databases with NONE encoding.

12. Improvements in displaying dark visual schema.

13. Other minor improvements and fixes.

 

Version 6.2

1. Processing of new data types added: DECFLOAT, REAL, BINARY, VARBINARY.

2. Improvements in debugging triggers and procedures.

3. The arguments of functions and procedures from the package are added to the autocompletion list.

4. On Update and On Delete actions are now displayed in FK list in table editor.

5. SQL script gets editable in the Duplicate wizard.

6. Zooming works smoother in Database Designer now.

7. The issue of working with BOOLEAN parameters in SQL Script resolved.

8. In some cases SQL Editor tabs cleared after updating host alias. Fixed now.

9. Improved interface and printing options in dark visual theme.

 

Version 6.1.2

1. Increased performance of Dependency tree.

2. Better processing of scaling in Database designer.

3. Columns are now displayed for views in Database designer.

4. New Query Data editor is opened empty with Shift+F12 now.

5. The Average Fetch Time value corrected in the Query Statistics.

6. Dark visual theme is not applied on printing dataset now.

7. The error occurred in EXECUTE BLOCK on use of NUMERIC or DECIMAL parameters.

8. Domains are validated on debugging procedures now.

9. The size of large databases is displayed right in the Database Properties now.

10. Scrolling has been improved for specific user cases.

11. Other improvements and bug fixes.

 

Version 6.1.1

1. Temporary tables icon added to the DB Explorer.

2. Recent values are now pre-filled automatically for parameters in SQL Editor.

3. The error occurred on running EXECUTE BLOCK. Fixed now.

4. Client sorting works smoothly now for all data types.

5. Current generator value can now be changed from object editor.

6. Return values for INSERT ... RETURNING statement are displayed correctly now.

7. Some improvements in working with Embedded server type.

8. Some minor issues with localizations fixed.

9. Other minor improvements and fixes.

 

Version 6.1

1. INT128 data type support for Firebird 4.

2. Implemented support for query interrupting in Query editor.

3. Support for Windows 11 ARM.

4. Host aliases added.

5. Added the ability to specify an encryption password on connecting to Interbase databases.

6. Added the ability to securely connect to the database with the isc_dpb_no_db_triggers option.

7. Added an option that disables automatic host availability check.

8. When renaming a table field, it was moved to the end of the field list. Fixed.

9. Scrolling the window with a mouse on hovering.

10. The value of the auto-increment field generator is now shown in the table editor in the field list.

11. Support for new generator options in Firebird 3 and higher.

12. Fixes in Event Monitor to get all notifications.

13. Corrections and improvements in the dark visual theme.

14. You can manually add transaction options in the database settings now.

15. Other changes and improvements.

 

Version 6.0.2

1. Improved processing of Unicode data.

2. System-generated indices are no longer generated in Extract database wizard.

3. Better processing of embedded servers, including old versions.

4. Default value can be disabled in domain editor now.

5. Parsing of procedures containing cursor has been improved.

6. Other minor fixes.

 

Version 6.0

1. Support of dark visual scheme added.

 

 

2. The new look with updated icons.

3. Editor tabs can be now highlighted with the specified database color.

4. Improved support of high-DPI monitors and large-scale fonts.

5. Support of Unicode for object names added.

6. Support for custom server aliases implemented.

7. Improved search when using regular expressions.

8. JSON tab added for viewing data.

9. SQL parser improved for better performance.

10. Timezone support implemented.

11. Updated SSH library with ECDSA and Ed25519 support.

12. Many other improvements and fixes.

 

Version 5.5.4

1. Connection to Firebird 4 can be established successfully now.

2. Extract database. FK and PF were not processed correctly in some cases.Fixed now.

3. HEX is now supported in the debugger and parser.

4. Fix for authentication in Firebird 1.5 Embedded.

5. Fix domain editor called from procedure editor.

6. Out parameters are now processed correctly.

7. Other minor fixes.

 

Version 5.5.3

1. Support of Unicode is added to data filters now.

2. The error of processing arguments for some types of UDFs fixed.

3. The Browse button for selecting the local database was disabled in some cases. Fixed now.

4. Some domain-based variables were processed as Cursor in the debugger. Fixed now.

5. Query builder. Improved resolving of table aliases.

6. Sometimes query results were read-only. Fixed now.

7. Successfully executed queries are now correctly saved in the log.

8. A few fixes in grid levels.

9. DB Explorer tree is refreshed OK with Sort by aliases option enabled.

10. Unique option can be selected for expression index now.

11. We added the possibility to clear parameters history for procedures.

12. Data is sorted correctly locally in asynchronous mode now.

13. Many other bug-fixes and improvements.

 

Version 5.5.2

1. Password field for encrypted databases has been added.

2. SQL Script performance has been improved.

3. Several triggers can be selected for activation and de-activation now.

4. Minor issues fixed in the debugger.

5. The error on filtering data on the client side has been fixed.

6. Functions with declared functions are supported now.

7. Views were not displayed correctly in VDBD. Fixed now.

8. ARRAY data type is processed correctly now.

9. Field types based on table fields are displayed correctly now.

10. Variables in DB triggers were not refreshed correctly. Fixed now.

11. Grant All\Revoke All operations for table fields work correctly now.

12. Search in the DB tree terminated on opening or closing the folder. Fixed now.

13. Many other fixes and improvements.

 

 

Version 5.5.1

1. The protocol for Firebird 3.0 was detected incorrectly. Fixed now.

2. The length for text fields was calculated incorrectly in Export Data wizard. Fixed now.

3. Varaibles were not displayed correctly in object editors. Fixed now.

4. Some fixes in UDF editor.

5. The errors of executing script with DECLARE FILTER statement fixed.

6. Other minor fixes.

 

Version 5.5

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

 

Version 5.4.4

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

 

 

Version 5.4.3

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

 

 

Version 5.4.2

1. The errors of executing the script in SQL Script and SQL Editor have been fixed.
2. Transaction was not closed on connecting to InterBase databases. Fixed now.
3. The views are opened correctly now.
4. The list of fields was not loaded on creating SUID procedures. Fixed now.
5. Data Import. Numeric data is imported correctly now.
6. VDBD performance has been improved.
7. Many other fixes and improvements.

 

 

Version 5.4.1

1. Constant strings containing comma were handled incorrectly. Fixed now.
2. Fixed errors of opening Load/Save dialogs in SQL Editor.
3. Loading some large sets of data caused the 'Access Violation' error. Fixed now.
4. There were 'List index out of bounds' errors while working with SQL Editor tabs. Fixed now.
5. Results of the queries starting with 'WITH ...' were displayed incorrectly. Fixed now.
6. Lots of other fixes.

 

 

Version 5.4.0.1

1. Support for new Firebird 3.0 features:

- SQL Functions and DDL Triggers editors have been added;

- Boolean field type support added;

- DEFAULT CHARSET option support added for the database;

- Linger Interval option support added;

- support for new user privileges added: ifpmUsage, ifpmCreate, ifpmAlter, ifpmDrop.

2. Description and NOT NULL attributes for tables are added with SQL statements instead of using system tables now.

3. Now trigger activity is changed without recreating a trigger, if possible.

4. Support for creating\editing\deleting users with SQL has been added.

5. Work with memory has been optimized.

6. Improved work with large BLOB data.

7. Some errors in PSQL debugger have been fixed.

8. The LOCAL protocol works correctly now.

9. Many other improvements and bug-fixes.

 

Version 5.3.0.1

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

 

Version 5.2.0.1

1. Windows 7 support
2. Preliminary support of InterBase 2009
3. Database Properties: added support of Embedded User Authentication (EUA) for InterBase 7.5 and higher
4. 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

5. User Editor / User Manager: for InterBase 7.5 and higher added an opportunity to work with Embedded Users
6. Role Editor: for InterBase 7.5 and higher added an opportunity to add Embedded Users to roles
7. Grant Manager / Permissions frame in object editors: for InterBase 7.5 and higher added the possibility to manage privileges on objects for Embedded Users
8. 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

9. 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

10. 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

11. Modal object editor windows are now resizable for the more convenient work
12. View Editor:for Firebird 2.1 and higher it is now possible to use Common Table Expressions (CTE)
13. 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.
14. 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

15. Keyboard Templates: added new keyboard templates
16. Query Builder: after loading a diagram from file the query was corrupted. Fixed now
17. Debugger:

• debugging an object containing EXECUTE STATEMENT caused an error. Fixed now
• Implemented support of procedures with Explicit Cursors

18. Export as SQL Script: export of Unicode data was performed incorrectly. Fixed now
19. Database Designer: Unicode text was displayed incorrectly in comments. Fixed now
20. 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

21. SQL Monitor: erroneous statements from SQL Script were now displayed by SQL Monitor. Fixed now
22. 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

23. 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

24. 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

25. A number of minor bug-fixes

 

Version 5.1.0.1

• Preliminary support of Firebird version 2.5
• Register Host wizard:

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:

Added options for setting up Data Grid modes for each database

The 'Sort by primary key' option is added, which allows sort data by the primary key on opening the Data Grid

• Options concerning transaction parameters are added to the Database Registration Info dialog which allows you to set them up for each database
• 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 restarting the program. 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 windows are now 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 opened SQL Monitor resulted in 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
• Extract Database :

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 for displaying parameter and variable values from different contexts in one window

The ability to delete/activate/deactivate all breakpoints at once is implemented

• Options:

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)

• 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

• Other minor improvements and bug-fixes

Scroll to top

 

Version 5.0.0.1

• Full InterBase 2007 and Firebird 2.1 support, including DB triggers, journaling and incremental backup
• Support of Unicode in SQL Editor, Query Builder, Grid View, Import/Export Data wizards
• Now you can continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder or while table or view data are being loaded to the editor. A query taking too long to execute can be aborted
• All wizards, including Import/Export Data wizards, Extract Database wizard, Services wizards, run in background mode now, allowing one to continue working with the program
• New advanced SQL Editor of the Visual Studio 2005 kind with Code Folding, UNICODE support, code completion, syntax highlight and other useful features
• Enhanced Import Data Wizard: now data can be imported up to 10 times faster; also added support of the following source file formats: HTML, XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007)
• Improved Export Data Wizard: now works faster; added several output file formats: XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007)
• Improved Extract Database Wizard works faster; now it also considers all object dependencies and allows defining the server version to generate the script for
• Improved DB Explorer in several respects: added a menu for generation of common SQL statements for database objects (Script to SQL Editor, Script to Clipboard) - it is now possible to get CREATE, ALTER, DROP, SELECT statements for each database object
• Now it is possible to save frequently used queries within the Favorite Queries node of DB Explorer; Favorite Queries can be stored either locally in Windows Registry (in this case they are only available for local users), or in a special table of the database (therefore, the queries can be accessed by all database users)
• Enhanced Database Designer: added new diagram objects (comment, virtual relationship); now it is possible to include Procedures, Functions and Views in the diagram; one can choose whether only object names or also fields and parameters should be displayed
• Dependency Tree tool can now be run in the background mode, so that you could continue working with the program
• Viewing database statistics ability extended. Now you can analyze temporary system tables (must be supported by server)
• Grid View improved: now the data of a sublevel of the Master or Detail table linked with the current table by a foreign key can be displayed automatically
• The ability to switch between the visual and non-visual modes in Trigger Editor, View Editor and Procedure Editor is implemented
• External plugin interface is restored
• Firebird database alias file support implemented
• Improved Procedure debugger with the Call Stack feature implemented. Now you can navigate your embedded calls of stored procedures easily
• Improved Table Editor: now, like in other object editors, the scripts that are connected with the changes made at the Editor window are accumulated and can then be executed at a time during compilation. A user can also select the scripts to be executed
• The options added that allow the relevant services stop, start and open a database automatically
• Added the Find Option tool which allows one to find the required option in the scope of all program settings, by a word or an expression from the option title
• The Recompute All service has been added which allows rebuild all database indexes (or just selected ones) or recalculate their statistics
• The Search Panel in DB Explorer is enhanced: now you can perform incremental search by names as well as define the search area
• For users’ convenience the Windows List function is implemented as a separate DB Explorer tab with the search ability
• In DB Explorer hosts are now named in accordance with the selected connection type (SSH tunneling or direct connection)
• SQL Script: ability to execute selected statements and statements under cursor added
• Enhanced reports management system
• A number of other improvements and bug-fixes

Scroll to top

 

Version 4.4.0.1

• Register Database Wizard:

The option that allows to skip refreshing objects on connection to database is added. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow

Import of database registration information from the previous version settings of SQL Manager for IB/FB is improved. Local databases are now registered according to the servers which use similar client libraries for connection

Embedded database registration has become simpler

'Copy Alias From' option is added in the new database registration dialog

It was impossible to register a database when there were no hosts registered. Fixed now

• InterBase 2007 partial support implemented. Now the UTF-8, UNICODE_BE, UNICODE_LE charsets are supported
• SSH Tunneling:

The ability to use one SSH tunnel to establish connection for several hosts/databases at the same time is added

Now it's possible to use tunneling for the services

• Field Editor:

New Field editor form

Now it's possible to fill the NOT NULL fields which have no DEFAULT value set with the data taken from the fields of the table being edited

• Data Grid:

The ability to display and edit ARRAY fields is added

When editing data or deleting records in a table which contains no unique or primary key, errors often occurred (the changes were not applied). Fixed now

It was impossible to edit a BLOB type field in Detail Level. Fixed now

• SQL Reference is available again now. It can be called from object editors
• Extract Database Wizard:

The ARRAY type data can be saved to an external file now

An option is added which allows to extract metadata of the objects on which the current object depends

The object dependency handling is improved

• Restore Database interface improved: now it is possible to register the server on which the backup copy will be restored
• Export as SQL Script: the ARRAY type data can be saved to an external file now
• Duplicate Object Wizard: now, when duplicating table data, the BLOB and ARRAY type fields can be duplicated
• SQL Script:

A script can now be executed from cursor; execution of the selected fragment is also possible

String comments (beginning with '--') are recognized correctly now

The ARRAY type data can now be imported from an external file when executing SET BLOBFILE statement

• Stored Procedure Debugger:

When performing input for the DECIMAL and NUMERIC type parameters the decimal delimiter used to change with a localization applied. Fixed now

The value of the empty string was treated as NULL. Fixed now

The FIRST statement is recognized correctly now

• UDF Editor/BLOB Filter Editor: Now there's no need to take an object's dependencies into account when changing its parameters
• Procedure Editor: support of BLOB type parameters for Firebird is implemented
• The Code Completion feature is implemented for table aliases
• Dependencies / Dependency Tree: when analyzing dependencies, the objects referred to in CHECK constraint bodies and COMPUTED BY table fields are now taken into account
• Other minor improvements and bug-fixes

Scroll to top

 

Version 4.3.0.1

• Export as SQL Script:

Now you can specify DBMS for which the script should be generated

Now it's possible to export BLOB field content into an external file with the ability to compress data. When executing the result script the data from the external file will be placed into the corresponding fields

• Extract Database Wizard:

To avoid errors during script execution the 'computed by' fields are moved to the end of table fields list; then their position is restored

Now it is possible to export BLOB field content into an external file with the ability to compress data. When executing the result script the data from the external file will be placed into the corresponding fields

• DB Explorer: the 'Add to Projects' command is added. Now objects can be added by specifying them in the corresponding dialog, as well as by dragging into Projects folder
• Dependency Tree: the ability to view dependencies for the domains that refer to other objects via check constraints is added, as well as dependencies for the tables that refer to other objects via Check constraints and those for the tables that use UDFs in their 'computed by' fields
• Data Grid:

The 'Expand All' and 'Collapse All' context menu items added

The 'Save column sorting' option is added for the 'Save and restore layout' mode

• CPU usage significantly decreased
• SQL Editor:

For the queries which allow data insert the ability to import data into the table implemented

The Ctrl+Shift+Enter shortcut for pointing out the corresponding item in DB Explorer tree worked incorrectly. Fixed now

Now it is possible to rename and move query tabs

Query execution time is now displayed in hh:mm:ss format

'Select All' command didn't work correctly on text that had very long lines (more than 4096 symbols). Fixed now

• Controls at the toolbars now remain after installing a newer version of the product. To bring them to their default state you can use the corresponding command from Windows menu or corresponding button in the Environment Options dialog
• Import Data wizard: when setting column correspondence for import from Excel, selecting a new column caused cursor to move to the first column in grid. Fixed now
• Database Registration Info: When applying changes, the originality of database aliases used not to be checked. Fixed now
• Database Designer. Switching to another visual scheme didn't take any effect on context menu style. Fixed now
• Localization:

Russian localization added

Corrections and improvements in German and English localizations

• Shutdown Database and Bring Database Online services are combined together and placed into Start/Stop Database wizard which allows using templates
• Domain Editor: the Collation was not displayed when opening Domain Editor. Fixed now
• SQL Script:

Executing DROP DATABASE statement with database name, login and password without having connected to it first

Now after dropping a database the 'Unregister Database' dialog appears

Handling the AutoDDL mode without SET AUTODDL statement execution

When DROP DATABASE and CONNECT statements are executed without user name and password the Login dialog appears

• Other minor improvements and bug-fixes

Scroll to top

 

Version 4.2.0.1

• German localization added
• Editor Options: Key Mapping is implemented to set the shortcuts for various commands/operations according to your needs
• Visual Query Builder: query execution plan is now displayed as a graphical diagram
• Dependency Tree: the diagram can now be printed
• Ability to call Register Database Wizard from SQL Script for the databases created is implemented
• SQL editors:

Next Bookmark, Previous Bookmark context menu items added

in some rare cases, an attempt to use Code Completion tool with 'Trim trailing spaces' option on, cleared all the line with 'Trim trailing spaces' option on. Fixed now

Dragging the field names from SQL Assistant works perfectly now

• SQL Editor: ability to execute statement under cursor added
• Database Designer: the Drop Table context menu item worked incorrectly if the field, not the table itself, was selected. Fixed now
• Import Data Wizard:

Now with the 'Commit changes manually' option switched on at the end of import you will be prompted for an action with transaction

Ability to resize wizard's window added

On setting format for fields to import, the 'Generator Value' and 'Constant Value' options used to be ignored. Fixed now

Having specified user-defined fields to import, the rest of them were filled with empty strings; so that default values defined for the fields were not applied. Fixed now

• HTML Report: ability to change header/footer of the report added
• SQL Script: abort executing script confirmation added
• DB Explorer: the context menu didn't hide when switching to another application. Fixed now
• Table Editor: the lines exceeding 32 symbols were truncated when exporting lists of subobjects. Fixed now
• Procedure Editor and Trigger Editor: parameters or variables deleted in editor window used to reappear in trigger/procedure body after compilation. Fixed now
• On attempt to execute a query or procedure with Date, Timestamp, Time typed parameters, the Conversion Error message appeared. Fixed now
• There were no checks for the type of file when creating a report by import from file, which initiated errors. Fixed now
• When creating a report, its components working with data used only the default client library, so that in some rare cases it was impossible to open reports working with the database on a local host. Fixed now
• Most memory leaks fixed
• SQL Script: the ability to re-execute the script which finished with errors added
• When editing the data containing fields with NULL values, changed data used to restore their previous values after commit. Fixed now
• Other minor improvements and bug-fixes

Scroll to top

 

Version 4.1.0.1

• DB Explorer: faster connection and refresh speed
• The ability to register multiple local servers is added
• Table Editor: errors used to occur when displaying data from the tables containing many records. Fixed now
• Dependency Tree: the search method for finding dependent objects is improved
• SQL Editor, Code Insight: fields of tables and views as well as keywords are now displayed in the drop-down list
• Create Database: wrong script for creating database used to be generated. Fixed now
• Domain Editor: the ability to set Charset and Collation restored
• Field Editor: the ability to set Charset and Collation restored
• Input Parameters: when opening the 'Parameters' dialog on executing the queries in SQL Editor and Visual Query Builder, an error occurred. Fixed now
• Form View: Memo fields editor is extended (can be customized in Grid | Advanced section of the Environment Options dialog)
• SQL Script: multiple windows can be opened now
• Database Designer: there were no changes seen in opened graphical diagram when the table name or any table field was edited. Fixed now
• The 'Keyword "DB_KEY" already in list' error message used to appear when connecting to FB 2.0 server. Fixed
• View Editor: the ability to process views containing FIRST as keyword in the queries added now
• View Editor: the ability to process views containing CAST as keyword in the queries added now
• Database Validation Wizard used to ignore the changes made on the first step, which caused an attempt to connect to current database and subsequent error. Fixed now
• Procedure Editor: the ability to use simultaneous names for variables in different procedures restored
• DB Explorer: after dropping a table, its triggers were still displayed in the DB Explorer tree. Fixed
• Field Editor: for autoincrement fields, on renaming the generator its name used to remain unchanged in the trigger's and procedure's body. Fixed now
• Other minor improvements and bug-fixes

Scroll to top

 

Version 4.0.0.1

Basic features:

 

Latest InterBase and Firebird versions support

• Compatibility with any Firebird server version up to 2.0
• Compatibility with any InterBase server version up to 7.5
• Trigger messages support
• Support of BLOB Filters

Significantly improved user interface

• New well-described Wizard System to perform complex tasks easily
• Fast access to most essential actions using Navigation bars in most of the windows
• New Windows Toolbar to switch windows easily, like in Windows Task Bar
• Office 11 and Windows XP visual schemes support

Improved Database Explorer

• Creating tabs for any tree node to access it in one-click
• Work with multiple selected objects at a time
• Much more convenient toolbar and context menu

Completely remade Database Designer

• Obvious new look
• Dividing diagram into different subject areas located on separate pages
• Navigating through diagram using preview navigation tool
• Creating/editing/dropping tables and table fields visually setting links between them
• Saving as image or printing database diagram
• Two diagram notations (IDEF1x and IE)
• A lot of visual customization options

New powerful data management tools

• Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
• Master-Detail View to work with two linked tables at the same time
• Table and Card Views to see data the way you like
• Ability to copy and paste selected records
• Advanced printing system
• Fully customizable interface

New and improved database object editors

• New procedure and trigger editors with enhanced precompiler
• New View Editor with automatic generation of view header and ability to create view using Query Designer
• Quick saving and loading in all database object editors
• Autosaving database object with opportunity to restore on further connection

New opportunities to work with SQL queries

• Possibility of creating queries with unions and subqueries visually
• Ability to view query plans in the form of a diagram

New connection options

• SSH connections support to encrypt client/server communications for increased security (most suitable in case of Internet connection)

Improved report management

• The new Create Report Wizard allows you to create a simple report in a few clicks
• Managing reports in the same way as if they were database objects: accessing reports directly through DB Explorer tree

and more...

Scroll to top

 

Version 3.9.5.1

• BLOB Editor: added horizontal and vertical scrollers in the text view
• Added more national character sets in the database creation window and the Database Properties form
• Improved localization files
• Added an ability to fill a newly created NOT NULL field with values of another field
• Added an ability to display privileges granted to the object at the DDL tab
• Now database error messages appear to be more informative. Now database error numbers is displayed in addition to the message texts
• Stored Procedure Debugger: fixed an error when working with data of TIME data type
• Database Designer: it was impossible to save large database diagram as image (*.jpg, *.png, *.gif, etc.). Fixed now
• Search in Metadata: while searching in large or remote databases, the manager hung up. Fixed now
• When losing connection to the database, it remained opened in the program. Fixed now
• Fixed an error with displaying views created with CHECK OPTION
• Fixed an error when changing database in the SQL Script Editor
• Fixed an error when creating index with a name in lowercase in a database of Dialect 1

Scroll to top

 

Version 3.9.0.2

• If a database had charset UNICODE_FSS or NONE, then the strings in local character sets didn't display correctly in editor Data tabs. Now in Database Registration Info you can manually disable encoding of Unicode strings to UTF8 to display data correctly
• Fixed the bug with incorrect processing of IF ... ELSE statements in Stored Procedure Debugger
• Stored Procedure Debugger: pre-compilation parser now supports ROW_COUNT, INSERTING, DELETING, UPDATING expressions
• The bugs with separate client libraries for each database are fixed now

Scroll to top

 

Version 3.9.0.1

• InterBase 7.5 full support
• Firebird 1.5 full support
• SQL Editor: renewed smart Code Insight and Highlight in the editors - now the list of all keywords is set depending on the current database server version
• Database Registration Info: an ability to choose a separate client library for each registered database was added
• The "Can't found Database Login dialog.." bug is fixed now
• DDL tab: fixed the problem with opening the tab
• It was impossible to create a domain of BIGINT type. Now the bug is fixed
• It was impossible to create an Autoincrement field of BIGINT type. The problem is solved
• Fixed the bug with 10000 length limit for CHAR and VARCHAR fields
• The bug with changing the field type from CHAR or VARCHAR to any numeric type is fixed now
• COLLATION for the text fields could not be created. Now fixed
• The ability to set CHARSET property for the BLOB types which don't support it is disabled now
• SQL Editor: the Result page didn't open after running a query which contained a comment in the first line, beginning with "--". The problem is solved
• Extract Metadata: the COLLATION property for the domains is shown correctly now
• Script Comparer: the column index value is counted correctly now in the scripts like "ALTER COLUMN POSITION ..."
• The current database was disconnected by timeout without possibility to re-connect when the Database Properties window was opened. The bug is fixed
• Completely remade Restore Database service
• Stored Procedure Debugger: solved the problem with not returning the output procedure parameter when running "EXECUTE PROCEDURE ... RETURNING_VALUES ..."
• Stored Procedure Debugger: pressing the Reset button does not cause erasing breakpoints now
• Stored Procedure Debugger: incorrect results were shown in case of existence "FOR SELECT ..." clause. Fixed now
• Stored Procedure Editor: the output procedure parameter wasn't returned if the procedure was run without SUSPEND. Now it is solved
• View Editor: it was impossible to edit simple views. Fixed now
• Window size and position were set incorrectly by default in SDI mode on multi-monitor systems. Now the bug is fixed
• Export Data: an exception arose when trying to export data to CSV. Fixed now
• Some minor improvements and corrections

Scroll to top

 

Version 3.8.5.1

• SQL Script Editor: we have added the possibility of executing the construction 'CREATE OR ALTER'
• Eliminated the error with changing the field type from INTEGER to BIGINT when working with Firebird server
• Extract Metadata: disabled generation of SQL statements for indexes that correspond to the constraints
• Extract Metadata: the error with limiting precision to 5 in NUMERIC field types is eliminated
• Extract Metadata: we have added the showing CHARACTER SET property for input and output parameters of the stored procedures
• Extract Metadata: eliminated showing COLLATE and NOT NULL properties for domain-based fields
• Search in Metadata: fixed the bug with hanging-up the program on trying to start search with an empty string
• The 'Access Violation' arose when closing database if the connection to the server was lost. The problem is fixed
• 'Database | Disconnect from Database' item of the main menu now works fine

Scroll to top

 

Version 3.8.0.1

• Duplicate Table: with this version you can copy the table data just as the table structure
• Print Data View: now you can customize column widths using the new dialog that is accessible through the Tune Column Widths button on the toolbar of the Print View tab
• Reports: with this version you can save your reports to XLS, RTF, HTML, JPEG, BMP, and TIFF files. We have added the new save filters for this purpose
• Print Data View: now the program saves page settings
• Print Data View: now the program displays the table name on each page of the report
• Print Data View: fixed a bug that caused incorrect showing of the table report after changing page parameters. Now the program correctly shows printable reports for tables
• Duplicate Object: fixed a bug that appeared when trying to duplicate an object if the program established connection to two databases simultaneously
• Export to Excel: we have added an ability to set values of the defined cells, merge cells, and define the page background
• Export Data: fixed a bug with appearing of the dialog window when clicking the file name in the edit field
• A bug with displaying and editing bigint fields is fixed
• Some minor improvements and corrections

Scroll to top

 

Version 3.7.0.1

• We have significantly improved the Export Data dialog: now you can add notes, hyperlinks, and charts based on exported data to Excel documents; you can also define graphical styles for column captions, data, footer, and header on export to RTF documents; a possibility to define strip styles is also included
• We have implemented the Dependency Tree tool: now you can view all the object dependencies in one diagram. To call this tool, use the Tools | Dependency Tree main menu item, or the corresponding button on the toolbar of any object editor
• Now the Register Database dialog supports .fdb files
• We have implemented the BIGINT fields support for Firebird 1.5
• Edit Field: now you can add the primary key using the Edit Field dialog if the table has no primary key
• Extract Metadata: added a possibility of extracting views in a user-defined order
• Editor Options: we have added a new option allowing you to define if keyboard templates apply in comment blocks or not
• We have added the "Number of dropping down items from object list in an editor window" option to the Windows page of the Environment Options dialog. This option defines how many objects are displayed in the drop-down list of objects on the toolbar of any object editor
• HTML Report: BIGINT fields and Universal triggers are shown correctly now
• A bug with using universal triggers in Firebird 1.5 is fixed
• Data Import from MS Access: one table appeared several times in the table list. Now it is fixed
• Some minor improvements and corrections

Scroll to top

 

Version 3.6.5.1

• We've implemented the support of Firebird 1.5 universal triggers. Starting from this version, IB Manager allows you to define several actions for a trigger, such as BEFORE INSERT OR UPDATE, for example. Trigger Editor has been slightly redesigned for this purpose
• We've significantly improved the Import Data Wizard to make most of new abilities of EMS QuickImport 2 component suite (http://www.ems-hitech.com/quickimport/) available in IB Manager, such as import from XML, import from multiple Excel sheets, importing formulas from Excel, case insensitive replacements, and more (*)
• We've added a possibility to hide/show the DB Explorer tabs, such as Project, Windows and Recent. If you don't need some of them on the screen, you can uncheck the appropriate options on the DB Explorer tab of the Environment Options dialog
• We've added the "Show only connected databases for services" option to the Environment Options dialog. If this option is checked, only the connected databases will be available in the service dialogs, such as Database Validation and Database Statistics. This option is available on the Tools page of the Environment Options dialog
• Fixed a bug with skipping the first statement of a script during its execution from SQL Script Editor in some cases
• If the list of the stored procedure parameters has been edited just before the procedure execution, the procedure parameter order was generated incorrectly. Now it is fixed
• Fixed a bug with incorrect type of the last variable displaying in the Stored Procedure Debugger in some cases. (*)
• Fixed a bug with generating the DDL for an object containing '#' or '%' character in its name
• Fixed a bug with displaying calculated fields in the Edit Field dialog
• Fixed a bug with the search/replace function executed for the selected text only
• Some minor improvements and corrections

Scroll to top

 

Version 3.6.0.1

• We have significantly improved Stored Procedure Debugger: now it is possible to trace into a procedure executed from the current one, using the 'Trace into' button and then return to a previous procedure quickly using the 'Run until Return' button. These functions are also available through the F7 and Shift+F8 key shortcuts respectively (*)
• We have added a Japanese localization to the IB Manager distribution package. Now ten languages are available: English, German, Italian, Spanish, Dutch, Russian, Polish, Brazilian, Hungarian and Japanese
• Database Designer: we have extended a possibility to save diagrams as graphical images. Now you can save your diagrams to four graphical file formats: bitmap, JPEG image, GIF image and Windows metafile. This feature is available through the 'Save as Image' button of the toolbar (*)
• Object description definitions are now extracted as UPDATE ... SET RDB$DESCRIPTION = ... statements for Firebird 1.x databases, since Firebird server supports inserting multi-line strings to BLOB fields
• Grant Manager provides two new menu items now: 'Grant All on All' and 'Revoke All on All'. Use them for granting or revoking all privileges on all objects to the current object
• Query parameters are parsed correctly by Query Designer now (*)
• Fixed a bug with setting object names in lower or mixed case in object editors if Firebird database is used
• Fixed a bug with incorrect field order in the INSERT statement generated by the Export Data as INSERT dialog (*)
• NUMERIC and DECIMAL fields doesn't change their types to INTEGER or DOUBLE PRECISION after trying to change the dimension anymore
• Now the Compare Scripts feature generates the result script correctly for tables with different fields order
• HTML Report generates trigger descriptions correctly now (*)
• The 'Transaction is active' message doesn't appear anymore after calling the windows list while the Data tab of Table Editor is active
• Identifiers appearing in the IN (..) clause are parsed correctly by Query Designer now (*)
• Fixed a bug in the Stored Procedure Debugger with retrieving the count of variables if type conversions are used in the procedure (*)
• Some minor improvements and corrections

Scroll to top

 

Version 3.5.0.1

• Database Designer: we have added a possibility to save the diagram as a bitmap. Now you can save you diagrams to graphical files using the 'Save as Image' button of the toolbar (*)
• Data View: we have added a possibility to set filter to the Grid View. Now you can filter the current data view using drop-down arrows on the right of the column captions
• The Create Procedure function is now available for views as well as for tables
• Now you can hide the Object Explorer tree from object editors permanently by disabling the "Automatically show Object Explorer..." option on the Tools page of the Environment Options dialog
• The Validate Database option is now enabled by default in the Database Validation dialog to avoid the 'Unsuccessful execution...' error raised if no options were selected
• DB Explorer: a database closes automatically now if the connection to it has been lost for some reason. It prevents the application from hanging up due to impossibility to disconnect from a database
• Export Data and Export Data as INSERT items are also available for views in DB Explorer now (*)
• Character set in the Print View corresponds to the database charset now (*)
• Fixed a bug with representing the dependencies in View Editor
• Fixed a bug with adding a trigger using the object explorer of Table Editor. Now names of trigger types appear correctly in the explorer
• The 'Grant/Revoke on All' menu item works correctly in Grant Manager now
• Fixed a bug with generating a wrong CREATE TABLE statement in the Export Data as INSERT dialog in case of selecting the fields for export manually from the dual list (*)
• Fixed a bug with DATE/TIMESTAMP values format in the Stored Procedure Debugger (*)
• Fixed a bug with BLOB fields truncating during the import data process (*)
• Fixed a bug with the 'CONTINUE record missing' error while importing data from some Excel files (*)
• Query result does not become read-only anymore if more than one space appears after the FROM keyword
• Fixed a bug with the fetching status window in the SQL Editor if the 'Fetch All' option is enabled
• Fixed a bug with using aggregate functions within the SELECT statement in Query Designer (*)
• Some minor improvements and corrections

Scroll to top

 

Version 3.4.0.1

• We have significantly improved stored procedure/trigger parser as well as Stored Procedure Debugger (*). Now it supports all SQL language extensions for Firebird 1.5 (such as defining variable in its declaration, EXECUTE VARCHAR syntax, CASE syntax), IB 6.5 (such as ROWS syntax) and IB 7.0 (such as BOOLEAN type)
• Extract Metadata Wizard: we have improved the algorithm of extracting stored procedures to avoid conflicts during their creation. Now you can extract stored procedures as a block of the CREATE PROCEDURE statements with empty bodies preceding another block containing their actual bodies defined in the ALTER PROCEDURE statements. This possibility can be disabled by the 'Extract stored procedures with empty bodies first' option, which is enabled by default
• We have added a possibility to load an Extract Metadata template automatically on calling the wizard. Now you can set the 'Automatically load template on run' option (Environment Options -> Tools -> Extract Metadata) and select the template file to load on each wizard execution
• Import Data Wizard: now you can log all the SQL commands executed during the import process into a file. Use the 'Enable SQL Log' option on the last step of the wizard for this purpose (*)
• Now you can use CONTAINING and STARTING WITH syntax within the WHERE clause in Query Designer (*)
• Fixed bug with "Transaction is not active" error occurrence on commit in the Import Data Wizard (*)
• Query Designer doesn't slow down the system anymore (*)
• Fixed bugs with creating folder and adding objects to the Project View tree of DB Explorer
• Fixed a bug with impossibility of saving changes in SQL Script
• Now data table list is properly restored from a template in the Extract Metadata Wizard
• Data exported to MS Access table started to print even if the corresponding option was unchecked. Now it is fixed (*)
• Fixed a bug with loading data into the BLOB Editor/Viewer using hexadecimal editor's local menu (*)
• The UPDATE or INSERT mode of the Import Data Wizard imports data properly now (*)
• Fixed a bug with autogrants during creating a trigger
• Some minor improvements and corrections

Scroll to top

 

Version 3.3.0.1

• InterBase 7.0 BOOLEAN type is supported by IB Manager now
• Import Data: a possibility of defining the import mode was added. Now you can define how the records from the source file must be imported to the destination. Six modes of data import are available, which allow you to add all records, add new records only, update or delete existing records in various ways (*)
• Export Data: a possibility of customizing multi-file export was added to HTML options. Now it is possible to set the maximal count of records in single file, availability of index file and navigation options (*)
• Query Designer: a possibility of diagram saving/loading was added. Now you can save the current diagram layout to external file for later use (*)
• Page options were added to the PDF Options page of the Export Data dialog. A possibility to set page size, orientation and margins is available for export to PDF format now (*)
• The 'Autoconnect on Startup' option was added to the Database Registration Info dialog
• If the Show Hosts option is enabled, databases are grouped by hosts now in the database lists of all program tools, such as SQL Editor, Table Editor and others
• New InterBase 7.0 TMP$ objects are also marked as system now
• Fixed a bug with impossibility of editing parameters and variables values of CHAR and VARCHAR types in the Stored Procedure Debugger window
• Fixed a bug with multiplying of VARCHAR domain size by 3 in the Domain Editor if the UNICODE_FSS character set was specified
• Fixed a bug when the DDL was improperly generated for multiple keys definitions
• Now it is possible to check/uncheck fields in the list when creating view or procedure for a table from Table Editor
• Fixed a bug with conversion exception raised in the Stored Procedure Debugger window for DATE parameters if system date format is different from InterBase one
• Fixed a bug with impossibility of setting the Underline option for a font on the Color page of the Editor Options dialog
• Fixed a bug with improper displaying of the CHECK expression in Domain Editor
• Fixed a bug with generating field descriptions in HTML Report
• Fixed a bug with displaying system objects in SQL Assistant if they are in separated node
• Compare SQL Scripts: fixed a bug in ALTER TRIGGER syntax. Also if two tables have different primary keys, the DROP statement will be generated for the current primary key of target table before the CREATE one
• Some minor improvements and corrections

Scroll to top

 

Version 3.2.5.1

• Database Designer: customizing of the color palette and object appearance was added. Now it is possible to change the appearance of the designer totally by specifying colors and options on the Database Designer page of the Environment Options dialog *
• Two new grid options were added in addition to the 'Fit columns widths to grid width' option: the 'Save grid view' and 'Autofit columns' options. The 'Save grid view' option should be chosen if you wish grid columns to be saved and restored during the next session. The Autofit columns option will fit column widths to their most wide values
• The 'Set Defaults to All Child Windows' item was added to the Windows menu. This item sets all the child windows to their default sizes and positions. This function is also available through the Ctrl+Alt+D shortcut
• Data View: now it is possible to search for the desired value in the current column by typing it in the grid, if the 'Enable auto search in grid' option is checked
• The 'Always Open the Fields Tab' option works properly now
• Fixed a bug with using AltGr key for typing characters in editors
• Fixed a bug with incorrect generation of the ON DELETE/ON UPDATE statements if active program language is different from default
• Fixed a bug with closing all the child windows even if the Cancel button was pushed in exit confirmation dialog
• Fixed a bug with disabling the 'Show servers in DB Explorer' option in the Environment Options dialog
• Fixed a bug with hiding/showing the DB Explorer window by pressing the F11 key
• Some minor improvements and corrections

Scroll to top

 

Version 3.2.0.1

• Autogrants functions were implemented. Now you can automatically grant privileges to stored procedures, triggers and views. This feature is available via the corresponding button of the Procedure Editor, Trigger Editor or View Editor and also via the popup menu in DB Explorer. It's also possible to set grants when objects are compiled. Set proper options on the Tools page of the Environment Options dialog for that purpose
• A possibility to increase/decrease spinner values in the grid cells using Ctrl+Up and Ctrl+Down combinations instead of Up and Down. You can enable this feature by setting the Use Ctrl+Up to increase spinner values option on the Grid page of the Environment Options dialog
• An ability to show only connected databases in the drop-down menus was added to all object editors and database tools. This option can be enabled by the corresponding check-box on the Tools page of the Environment Options dialog
• The DB Explorer state (if it is visible or not) is stored in registry now
• The 'Smart Tabs' option was added to the Editor Options dialog. Enable it if you want to have tab width values depending on upper lines, or disable it if you want to use tab width values specified by the 'Tab Stops' option
• Auto search feature is available in SQL Assistant, Query Designer and Database Designer now
• Database Designer: the Delete key now closes active table(s) in a diagram, Shift+Del is used to drop a table, Ctrl+Del deletes fields within an active table *
• A possibility to edit the page size manually is added to the Create Database wizard
• Object descriptions are displayed properly in DB Explorer if 'Show Table Description' is on
• Stored Procedure Editor displays an error dialog if an exception was raised while executing the procedure
• Fixed a bug with 'Can't focus disabled or invisible window' error message after opening Table Editor with the Dependencies, Triggers or Description page active
• Fixed a bug with closing the View Editor after recompiling a view
• Fixed a bug with "Object ... in use" error during view recompiling
• Fixed a bug with "List index out of bounds" error while changing autoincrement initial value of a trigger
• Domain info is visible now in the Add/Edit Column dialog
• Fixed a bug with extracting objects having names beginning with a digit
• Fixed a bug with program crashing during export of BLOBs to DBF (see Export Data dialog) *
• The Compare Script feature is unavailable until both files are specified. It prevents from receiving the I/O error after pushing the 'Finish' button when file name(s) are not specified
• The Show Tips feature shows the next tip on startup now
• Fixed a bug with the incorrect behavior of the View Procedure Header button in Stored Procedure Editor
• The External Tools submenu now available in the Tools menu (see External Tools)
• The 'Set Default Link Color' button works properly in Database Designer now *
• Fixed a bug with improper behavior of child windows in MDI environment mode
• Some minor improvements and corrections

Scroll to top

 

Version 3.1.0.1

• Dutch localization was added to IB Manager distribution package. Now six languages are supported: English, German, Italian, Spanish, Dutch and Russian. This list will expand from version to version. You can change the program language through the Options | Select program language... main menu item. IB Manager also allows you to select your language preference at first startup (see Select Program Language)
• Query Designer was updated to the latest version of EMS QueryBuilder suite (http://www.ems-hitech.com/querybuilder/); a lot of small improvements and corrections have been made
• Database tools (e.g. SQL Editor, Query Designer *, Database Designer *) now switch to the active database automatically each time when the tool window becomes active
• Database Designer: a possibility to hide/show grid in database objects was added. This option is available in the Database Designer window through the 'Show Grid in Objects' item of the Display Mode button drop-down menu *
• SQL Script: now the database drop-down list updates itself in compliance with the databases currently active and reverts to its initial state if the assigned database closes
• The User Manager window behaviour was changed. It is not a modal window now and it looks like other child windows of the application
• Print Metadata window has also changed its style *
• Database Designer & Query Designer: these two windows were redesigned to avoid undesirable toolbar behaviour *
• The Login prompt dialog appears now if no password is specified in the Database Registration Info
• "FDB" file extension became a registered file type. Now you're able to register/open Firebird databases by starting a database file from Windows shell
• Some corrections were applied to User Manager; adding role and some other functionality is now available
• Fixed a bug with "List index out of bounds" error in the Search in Metadata function. Several minor bugs were also fixed
• Compare Scripts Wizard: fixed a bug with CHAR/VARCHAR fields which have default values containing more than one word
• DB Explorer: fixed bug with disappearing object names in the SQL Assistant after switching from the Databases tab to the Windows tab and back again
• Some minor improvements and corrections

Scroll to top

 

Version 3.0.0.1

Basic features:

 

New features – new name!

• QuickDesk changes its name to IB Manager!

New, modern, and fully customizable user interface!

• See Editor Options for details

MDI Interface implemented

• Microsoft Office Style - all program windows are child windows of the main window now. You can customize the Environment Style using the the Environment Options window

HTML Report Generator

• Create a detailed HTML report of your database quickly

New Query Designer

• Full support of FB 1.x and IB 6.5 select enhancements

Plan Analyzer

• Helping you easily understand the query optimization plans in SQL Editor

Multilanguage support

• Spanish, Italian, German and Russian localizations available, Dutch localization is coming soon

Backup and Restore Templates

• Make backup and restore even more quickly

New Compare SQL Scripts Module

• Working much better than the previous one

Data Export to PDF and MS Access

• Two more popular formats added

Scroll to top

 

 

---