Frequently Asked Questions (FAQ)

Which Firebird versions are supported?

Firebird 3, 4 and 5 are supported with their features: packages, stored functions, external routines (UDR), identity columns and the data types INT128, DECFLOAT, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE and BOOLEAN. Older servers such as Firebird 2.5 can be used without those features.


Which client library do I need?

Select the client library (fbclient.dll) of your Firebird installation in the connection (Connection > Client library). The x64 version of the program needs a 64-bit x64 client library and the x86 version a 32-bit x86 client library. The Arm64 version is an Arm64EC program and uses the x64 client library.


How to open a database without creating a connection first?

Give the database file (.fdb, .gdb or .ib) as an application parameter, or drop the file on the program window. Dropping is controlled by Options > Application > Allow drop database files.


Can I import connections from other programs?

Yes. Connections can be imported from DBeaver (data-sources.json), InterBase Query (IBConnections.ini) and Firebird Editor Pro itself. Connections can also be exported.


What happens when the connection is lost?

A banner with a reconnect button is shown on the tab of the connection. The connection options also have an automatic reconnect with a retry interval.


How to run only a part of the SQL?

Select the text and run it (Ctrl+Enter). The selection is executed if there is one, otherwise the whole text.


Why can I not edit the result set of a query?

A result set can be edited when it can be updated to one table. The SQL editor shows the reason when a result set cannot be edited, for example with UNION or a common table expression.


How to export data?

Use export in a data grid. The formats are Text, CSV, HTML, JSON and Microsoft Excel, and for table data also SQL INSERT and SQL UPDATE statements.


How to save BLOBs as files?

Use Save BLOBs to folder in a data grid. File names come from the primary key or the first visible column and the file extension is detected from the content.


Is the program portable?

Yes, it is. Download zip package and use -appinipath application parameter (once). After the INI file is in the application path the use of -appinipath application parameter is not required.


How to save INI files into application path?

Use -appinipath application parameter. If you don’t want to use INI at all, use -noini application parameter. See application params.


How to enable multiple instances?

Check Options > Application > Allow multiple instances or use -mi application parameter.


Is Firebird Editor Pro open-source?

Partly yes. You can find shared code from github: https://github.com/TextEditorPro/. The SQL editor is the TTextEditor control and the data grid is the TDatabaseGrid control.


Is the user interface available in other languages?

No, the user interface is in English.


What programming language you are using?

Delphi. The data access components are Devart IBDAC.