What's New

<<Download IBExpert|IBExpert| Online documentation>>

What's New?

IBExpert 2024.07.04

and bugfixes 2024.07.11, 2024.07.23, 2024.10.08

1. PSQL parser; Database Comparer

  • Improved parsing of parenthesized SELECT's (Firebird 5)

2. Script Executive

  • Support for parenthesized SELECT's added (Firebird 5)

3. PSQL Debugger

  • Implemented debugging of PSQL objects that contain subroutines that read/writes variables defined at the main level (Firebird 5)

4. Minor bugfixes and small improvements

IBExpert 2024.04.07

1. Database Registration

  • "Show server version mismatch warning" option added (Additional tab).

If this option is ON (default) IBExpert will compare the specified and the actual version of the database and warn in case of a mismatch with a choice of possible actions.

2. PSQL Debugger

  • Support for time zones implemented (Firebird 4, 5).

3. Data Grids

  • The possibility to dump blobs to file without preloading them into the IBExpert GUI has been implemented; it is available from the grid context menu.
  • Fixed the issue with incorrect representation of RDB$DB_KEY for tables with >2G records.

4. Code Completion

  • Fixed the incorrect behaviour when selecting/unselecting items in the list using the mouse.

5. Database Inside

  • Support for Firebird 5 databases.

6. SQL Editor, Statements History List

  • Added counters for page operations.

7. Database Comparer

  • Support for parenthesized SELECTs (Firebird 5) implemented.

8. Other minor bugfixes and small improvements

IBExpert 2024.01.22

Mainly bug fixes.

IBExpert 2023.11.22

Mainly bug fixes.

IBExpert 2023.10.27

1. Code Editor, Code Completion

Improved performance especially on databases with lot of objects. Suggesting possible joins based on existing relationships by foreign keys - call the Code Completion after JOIN keyword. There was a bug on some configurations in the previous version which caused IBExpert to freeze when the Code Completion is fires. Fixed in this version.

2. Database Inside

Support for Firebird 4 databases.

3. Partial support for Firebird 5 implemented

Support for all known syntax changes/additions in the PSQL parser:

  • SKIP LOCKED, WHEN NOT MATCHED BY SOURCE, parenthesized SELECTs etc.
  • However, there is NO support yet for parenthesized SELECTs in the Database Comparer.
  • Also the PSQL debugger doesn't allow to debug roitines with subroutines which reference variables in a main routine.
  • Support for new built-in functions in the Code Parameters hint.
  • Support for partial indices in the index editors and metadata extract.
  • Support for parallel workers in following IBEBlock functions: 
    ibec_BackupDatabase, ibec_RestoreDatabase, @Services.RepairDatabase.

There is a new option available - ParallelWorkers (or just Parallel) - which allows to specify number of parallel workers (e.g. ParallelWorkers=4)

4. Other minor bugfixes and small improvements

back to top of page

IBExpert 2023.09.13

Mainly bug fixes.

IBExpert 2023.03.06

1. Data Grid

  • Possibility to edit UUID/OCTETS values in the filter criteria tree has been implemented.
  • The mouse wheel can be used now to perform Page Up and Page Down actions.

By default the Ctrl key should be held to perform PageUp/PageDown. To change the default modifier put the following piece of code into an "After IBExpert starts" event block: 

   ibec_SetGlobalVar('IBE$DATA_GRID_PAGE_SCROLL_MODIFIER', <value>);

where <value> is one of following: empty string, null, 'CTRL', 'ALT', 'SHIFT'. An empty string or null as a new modifier value makes the PageDown/PageUp a default behaviour of the mouse wheel in the data grid.

2. Code Editor

  • Support of keyboard templates in the Code Completion list.

There is a new option "Show keyboard templates in the Code Completion list" in Options | Editor Options | Code Insight.

3. Automatic restore of dead connection

  • By default, if the database connection is lost IBExpert shows a dialog window and offers to restore a dead connection. To attempt to restore the connection automatically without user confirmation put following line of code into an "After IBExpert starts" event block: 
    ibec_SetGlobalVar('IBE$RESTORE_DEAD_CONNECTION', TRUE);

4. Database Object Editors

  • Support of object names longer than 31 chars (Firebird 4) where they were not yet supported.

5. Export Data

  • Export to clipboard in JSON format has been implemented.

6. Code Formatter

  • Support of space after opening and before closing bracket options.

7. Minor bugfixes and small improvements

back to top of page

IBExpert 2022.11.14

and bugfixes 2022.11.28, 2022.12.02 & 2023.01.03

1. SQL Editor

  • Execute with commit (Ctrl+Alt+F9) feature implemented.
    This executes a query and performs a COMMIT immediately for queries that don't return a record set.
  • Autocommit feature for the current SQL Editor (Ctrl+Shift+M) implemented.
    If ON non-select queries will be committed immediately. There is also a corresponding button on the toolbar and an item in the SQL Editor menu.
  • Convert SELECT / WITH into IBEBlock (Ctrl+Shift+B) feature.
    Converts the current select/with query into IBEBlock.
    There is also a corresponding item in the SQL Editor menu.

2. Metadata Search

Web-style search implemented. Rules are:

  • By default AND condition is used: 'declare variable' will find all DDL's that contain both 'declare' and 'variable'
  • To use OR place '|' between words: 'declare | variable'
  • OR has lower priority than AND
  • To exclude words from a search use '-' before a word (without a space):
    'declare -variable -procedure'
  • To search for an exact match put a word or phrase inside quotes:
    "declare variable"
  • Complex expressions with parentheses are not supported
  • 'Whole words' and 'Case sensitive' options are taken into account

Details can be referred to in our online documentation: Search in Metadata.

3. Support of version history for stored Firebird and IBExpert blocks

4. Visual Options

  • Disable undocked toolbars option. This prevents toolbars from undocking.

5. IBEBlock

6. Embed web technologies

It is just replacement of embedded Internet Explorer that is used in IBE Direct, Blob Viewer and some other parts of IBExpert, with embedded Edge.

The lastest IBExpert includes a new feature to embed web technologies (HTML, CSS, and JavaScript). So, instead of using an external program to display PDF or JSON, we have implemented Microsoft edge WebView2 support. The WebView2 control uses Microsoft Edge as the rendering engine to display the web content in IBExpert.

However, some Windows versions do not include WebView2 Runtime.

If you encounter an error when starting IBExpert, please download and install the correct WebView2 Runtime from https://developer.microsoft.com/en-us/microsoft-edge/webview2/#download-section for your OS version. Following installation, IBExpert should work as intended.

If you do not wish to install this additional Runtime on your server, you can disable (for the time being) WebView2 support and revert to using SumatraPDF by deleting WebView.dll and WebView2Loader.dll from your IBExpert install folder.

7. Minor bugfixes and improvements

back to top of page
<<Download IBExpert|IBExpert| Online documentation>>