Firebird Code Factory allows you to manage SQL scripts and queries using such useful features as code folding, syntax highlighting and code completion, build query visually, execute several queries at a timeexecute scripts from files, view and edit result data with filtering, sorting and grouping abilities.

The application is able to export data to as many as 14 file formats including here RTF, Excel, and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, and even build diagrams based on PostgreSQL data.

Here are some key features of "Firebird Code Factory":

· Visual Query Builder
Firebird Code Factory provides you with the powerful tool intended for designing queries as visual diagrams. This tool does not require any knowledge of the SELECT statement syntax, it will form a query automatically, you just need to mark what information you want to retrieve;

· Handy SQL Editor
Firebird Code Factory supports SQL query syntax highlighting and code completion to prevent mistakes in syntax at once. Also it is possible to separate SQL scripts into regions that can be individually collapsed or expanded.

· Simultaneous executing of several queries
Firebird Code Factory can execute each query in a separate thread in order to continue your work with the software while the query is executing.

· Advanced data management
Queries data are represented in grids with all corresponding features as viewing, editing, grouping, sorting and filtering to analyze the data in the most convenient way.

· Data export
Powerful tools for exporting data from Firebird tables and queries to most popular formats (MS Excel, MS Access, MS Word, HTML, XML, PDF) are at your disposal.

· Data import
Firebird Code Factory import features were intended to simplify your everyday work. You can import data from MS Excel, MS Access, XML, DBF, TXT, CSV formats.

· Powerful BLOB Viewer/Editor
With Firebird Code Factory you can view or edit BLOB data in the following ways: hexadecimal dump, plain text, graphical image or HTML page. A graphical representation of BLOB data supports five image formats: BMP, Windows metafile, JPEG, GIF and PNG.

· Full customization according to your preferences and needs
In Firebird Code Factory you can customize the behavior of all its tools, select a user interface scheme and set a lot of other preferences.


Requirements:

· Pentium PC or higher;
· 64 MB RAM (128 MB recommended);
· 10 MB of free hard disk space;
· SVGA-compatible video adapter;
· Internet Explorer 4.0 or higher.
· Server environment - Firebird server version 1.0/1.5/2.0.


Limitations:

· 30 days trial

What's New in This Release: [ read full changelog ]

DBMS-related features:
· Support of Unicode/UTF-8 data has been implemented.
· The Quick Connect mode has been implemented. Use it to skip metadata refreshing when connecting to a database.

Interface improvements:
· The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is implemented. It can be invoked by means of the Format SQL link on the SQL Editor's navigation bar (Ctrl Alt D shortcut).
· The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor.
Some new features have been incorporated into SQL Editor and SQL Script Editor. Now it is possible:
· comment/uncomment selected text (Shift Ctrl . / Shift Ctrl , shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift Ctrl , having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
· convert selected text to different cases (lower, UPPER, and NameCase);
· export the contents of the editor to RTF and HTML formats (to file or to clipboard);
· create a new query, close existing one, save the query to profile, etc. using a popup menu that has been added to each query tab;
· print/preview the contents of the editor;
· use the script runner to execute large scripts without opening them in the editor window.
Data Grid has been significantly updated:
· Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table�s columns within the dropdown window.
· Now the grid automatically switches to the Simple mode for queries that return more than 5000 records (the number can be customized in the Options dialog). This mode allows you to get thousands and millions of records displayed in a few seconds, but does not feature filtering, grouping and sorting abilities.
· Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).